Pivot table turning static in Excel 2007

H

hasmuk

Hi,

I'm having a major issue saving pivot tables as Excel 97-2003. When I
insert calculated fields into a pivot table, and save the file, my pivot
tables turn into static tables!! When I used the previous version of Excel,
I had no problems with my calculated fields.

How can I save a pivot table in previous format, whilst using Excel 2007,
but still have the pivot table function?

Thanks for your help,
H
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Power Pivot. Yikes. 0
Doughnut Chart linked with the slicer in the pivot table 0
Excel 2007 pivot table using analysis services cube as data source 0
Slicers and Calculated Items in Pivot Table 2
Additional columns for Pivot table 0
Pivot Table Counting Text Data 0
Excel 2007 vlookup with Pivot table 0

Top