Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveCopyAs corrupts pivot tables
I've got an Excel 2003 workbook that contains a couple of pivot tables which
work fine. The workbook also has a custom menu item that runs the SaveAsCopy method to serve as a backup of the open workbook with a predetermined naming convention and location. This also works fine. My problem is if I refresh a pivot table and run the SaveAsCopy method, in either order, then close the workbook, I get "Unable to Read File" error the next time I open the workbook. After clicking OK, the file does open, but a "Repair.." window is displayed explaining that the PivotTable Report "was discarded due to integrity problems". Does anyone have any ideas on what could be happening and how to address? thanks -- D.Farns |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Additional Indo: SaveCopyAs corrupts pivot tables
If I refresh the pivot table using the "Refresh Data" option on the Data or
PivotTable menu I can run the SaveAsCopy method and NOT get the Unable to Read File error next time I open the file. However, the pivot tables in this workbook are refreshed via a line of code in a sub procedure which does cause the error when SaveAsCopy is also run. I suspect I need to change my PT refresh code. Here's what I'm using today to refresh: Worksheets("MySheet").PivotTables("MyPT").PivotCac he.Refresh -- D.Farns "D.Farns" wrote: I've got an Excel 2003 workbook that contains a couple of pivot tables which work fine. The workbook also has a custom menu item that runs the SaveAsCopy method to serve as a backup of the open workbook with a predetermined naming convention and location. This also works fine. My problem is if I refresh a pivot table and run the SaveAsCopy method, in either order, then close the workbook, I get "Unable to Read File" error the next time I open the workbook. After clicking OK, the file does open, but a "Repair.." window is displayed explaining that the PivotTable Report "was discarded due to integrity problems". Does anyone have any ideas on what could be happening and how to address? thanks -- D.Farns |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Pivot tables-controlling user interaction with pivot tables | Excel Programming |