Pivot table turning static in Excel 2007
 

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