SaveCopyAs corrupts pivot tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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").PivotCache.Refresh
 

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

Corrupt files due to pivot remnants after saving via VBA 0
Problem with pivot table when workbook is protected 1
refresh multiple pivot tables in workbook 2
Pivot Table Question 2
Please help! Cannot open pivotTable source file.... 2
All Pivot table include different pivot field to save as individualworkbook 5
Macro to Refresh child pivot table 4
Used Range and Source data of a Pivot Table 1

Back
Top