| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Excel 2007: "Reference is not valid" when refreshing pivot table
Hi all
I have a pivot table that works fine in Excel 2003. I've created an Excel 2007 version and some code fails because (in VBA) "The PivotTable report was saved without the underlying data". Yet, when I manually try to refresh the pivot table, I get a message saying "Reference is not valid". I've had a look at the source data, but there doesn't appear to be any issues with that. Can anyone suggest what the error might be? BTW, I'm not sure if I've cross-posted correctly (excel.misc & excel.programming), so apologies if this causes any problems. Thanks in advance Paul Martin Melbourne, Australia |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007: "Reference is not valid" when refreshing pivot table | Excel Discussion (Misc queries) | |||
| what does "data source reference is not valid' in Pivot table | New Users to Excel | |||
| Pivot Table "Data source reference is not valid" error cause? | Excel Discussion (Misc queries) | |||
| Pivot Table - Error "Reference Is Not Valid" | Excel Discussion (Misc queries) | |||
| OfficeXP "Cannot open pivot table source file" when refreshing pivot table | Excel Programming | |||
![Paul Martin[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
