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

Single Filter to change all Pivot Tables in a Workbook 8
Excel Pivot Table problem 8
Excel Pivot table - need to not remember old data which has been r 3
Clear row label data in pivot table 2
EXCEL07 how to use text in a PivotTable value field 1
Inputing data into Pivot Table 2
2007 Pivot to Access 1
2007 Pvt Group/Ungroup symbols 3

Top