excel corrupted and unrepairable - Are there ANY other options here? Lost 2 months of work
Posted on 2010-09-24
I have a rather large excel workbook (3MB) on my server. A couple users open it via a network shortcut. This morning one user had it open as usual and the power went out for about 1 hour.... ended up using up the battery backup and killing my server. Now 2 sheets in the file (about 2 months of work) are completely gone.
When I try to open the file it says "Excel found unreadable content in MY FILE NAME. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.
After excel attempts to repair it comes up with "Excel was able to open the file by repairing or removing the unreadable content." Then lists the following:
Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.
Replaced Part: /xl/worksheets/sheet8.xml part with XML error. Quote expected. Line 2, column 103564.
Replaced Part: /xl/worksheets/sheet9.xml part with XML error. Whitespace expected. Line 2, column 2308303.
Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)
Now 2 sheets are completely blank... losing over 2 months of work. I've tried a few different excel repair tools I found online but non have been successful.
My question is: Is there ANYTHING I can do to recover this? Are there companies out there that would specialize in something like this? It's 2 months of work so paying someone to help would be well worth it.
ANY ADVICE IS APPRECIATED!!
PS. The last server backup ran over a month ago.... so recovering the file from backup isn't much of an option.