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