500 Points Available - corrupt Excel file when trying to "Save"
Hi -
I have an Excel file that I created on Friday, Aug 20 with no problems. I created two copies (one backup, and one emailed out), and have not touched them since...until this morning. I opened the file again to look at it, did not change anything, but tried to resave the file before closing. At this point the file gave me the "Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience." message.
Data.xlsx
Here's more information:
Error Signature
AppName: excel.exe AppVer: 12.0.6535.5002 AppStamp:4bd2a7f1
ModName: excel.exe ModVer: 12.0.6535.5002 ModStamp:4bd2a7f1
fDebug: 0 Offset: 00b83c94
- It was stored locally.
- It has multiple queries stored in the first and second tab that I need to keep
Please help me figure out why this file is corrupt and how to fix it.
Please! Thank you
I have an Excel file that I created on Friday, Aug 20 with no problems. I created two copies (one backup, and one emailed out), and have not touched them since...until this morning. I opened the file again to look at it, did not change anything, but tried to resave the file before closing. At this point the file gave me the "Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience." message.
Data.xlsx
Here's more information:
Error Signature
AppName: excel.exe AppVer: 12.0.6535.5002 AppStamp:4bd2a7f1
ModName: excel.exe ModVer: 12.0.6535.5002 ModStamp:4bd2a7f1
fDebug: 0 Offset: 00b83c94
- It was stored locally.
- It has multiple queries stored in the first and second tab that I need to keep
Please help me figure out why this file is corrupt and how to fix it.
Please! Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I used Excel 2010 to solve your issue.
Go to File / Prepare for Sharing / Check for Issues / Inspect Document
it will ask you to save the file, say "No", as saving crashes Excel 2010 too.
On the next dialog, make sure all is selected and hit Inspect.
Under "Document Properties and Personal Information" you will see a bunch of issues.
I clicked "Remove All".
After that, file started saving normally.
My best suggestion is, as you said you wanted your queries, create brand new ones again.
Go to File / Prepare for Sharing / Check for Issues / Inspect Document
it will ask you to save the file, say "No", as saving crashes Excel 2010 too.
On the next dialog, make sure all is selected and hit Inspect.
Under "Document Properties and Personal Information" you will see a bunch of issues.
I clicked "Remove All".
After that, file started saving normally.
My best suggestion is, as you said you wanted your queries, create brand new ones again.
ASKER
**ANOTHER SOLUTION IF THAT DOESN'T WORK**
I also found another way to do it (in my desperation) -- I simply right clicked on each tab and copied the worksheet into a new workbook, then updated the links (Data>Edit Links> then I pointed it to the existing file)/