Once upon a time, while cranking away at our Web Analytics presentation, Dave tried accessing our main data file. To his horror, he got the following message: “Excel cannot open this file. The file might have been damage or modified from its original format.” We tried opening the spreadsheet in Office 2008 and on the Windows version, but nothing worked. We even tried the “Recovery Toolbox For Excel” and that did absolutely nothing.

Though we eventually had to recreate all of our data, I’ve recently stumbled upon the fix.
A classmate (thanks Karl!) recently told me that Office Open XML documents (docx, pptx, xlsx, etc…) are essentially zip files containing all of the document information. So on a whim, I tried the following, and it recovered the file!

- Rename the Excel document so that it has a .zip extension
- When prompted, click “Use .zip”
- Double click to open the file
- Choose “Save as…” and save the file as either xlsx, xls, xlsb…the more the merrier
I hope this helps someone out! If the fix works, please add a comment to let me know.