| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pvt Table Turned Into Static Values
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pvt Table Turned Values After Insert Calculated Field | Excel Discussion (Misc queries) | |||
| How do I turn off Static values | Excel Discussion (Misc queries) | |||
| Pivot table turned flat! | Excel Discussion (Misc queries) | |||
| Values from website turned into useable number values | Excel Worksheet Functions | |||
| Grand Total on Pivot Table turned on but no totals showing | Excel Discussion (Misc queries) | |||
Threaded Mode
