What changed between Excel 2007 and 2010 that is causing my copied worksheet save to fail?
- by snorehorse
When I do this in Excel 2010 this fails, but works in Excel 2007:
Create a new workbook and insert an image onto a worksheet, or get a preexisting worksheet with an image.
Copy the worksheet into a new workbook by clicking the worksheet tab and clicking Move Or Copy and then choosing (new workbook) as the destination.
Close the source workbook.
Attempt to save the new workbook.
The message is: "Errors were detected while saving 'myfilepathhere.xlsx'. Microsoft Excel may be able to save the file b removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving the file, click Cancel". Clicking continue brings up another file dialog window followed by more repair errors.
It seems behind the scenes it is looking to the source workbook when it tries to save the image in the new destination workbook. No useful error message, of course, thanks microsoft. But this problem never happened in Excel 2007.
The reason why I am closing the source notebook before the save, is because I don't need the end user to see it after I programmatically pull a coversheet (with the image) from it, in an interop app.
Thanks for any help.
Update: I don't encounter this problem if I open the source workbook as "Read Only" (I do this programmatically using Excel Interop).