Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
This pivot table report is not valid
I can create a pivot table, and everything works, but when I save the
workbook, close it, and then re-open it I get the above message for all of the reports. Can anybody help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
This pivot table report is not valid
OK - solved it, the data needed refreshing!!
"ukredskin" wrote: I can create a pivot table, and everything works, but when I save the workbook, close it, and then re-open it I get the above message for all of the reports. Can anybody help? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
This pivot table report is not valid
I have encountered the same problem when saving Excel 2007 reports in .xls
(2003) format. In this case the option to refresh data is not available - nor do any pivot controls (e.g. Pivot Wizard) function. Most of my colleagues are still on Excel 2002 or 2003 - this is becoming a real problem - is there something I am missing here? -- Mike Watkins "ukredskin" wrote: OK - solved it, the data needed refreshing!! "ukredskin" wrote: I can create a pivot table, and everything works, but when I save the workbook, close it, and then re-open it I get the above message for all of the reports. Can anybody help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table - Reference is not valid | Excel Worksheet Functions | |||
Pivot table - Reference is not valid | Excel Discussion (Misc queries) | |||
Pivot Table - Reference is not valid | Links and Linking in Excel | |||
The Pivot Table field name is not valid, | Excel Discussion (Misc queries) | |||
The Pivot Table field name is not valid, | Excel Discussion (Misc queries) |