Pvt Table Turned Into Static Values

C

C02C04

I have a worksheet (.xls) that holds data and built some pivot tables out of
it. It worked fine till today. The pivot tables were able to refresh with new
data. After saving it and re-opening the file all the pivot tables turned
into values. That is, all the pivot tables are now static values. I repeated
the process and the result is still the same. What could be the problem and
how to resolve this?

I am using Excel 2007.
 
J

Jacob Skaria

Please check the calculation settings under Tools|Options|Calculation.

If this post helps click Yes
 

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

Pvt Table Turned Values After Insert Calculated Field 0
Formula to Look up values from a pivot table 1
Pivot table report invalid 0
Embed the same Excel multiple times 0
Pivot table format on paste values 0
pasting values from pivot table still linked 0
Pivot table turning static in Excel 2007 0
Single Filter to change all Pivot Tables in a Workbook 9

Top