View Full Version : Corrupted Excel File
LowNSlow
28th Jul 2011, 22:09
I've got an Excel file that won't open due to unreadable content/corrupted content.
Does anybody have any recommendations on how to at least access the data?
mixture
29th Jul 2011, 07:12
Restore off your latest backup. :E
(Dunno... the very definition of corrupted data is that, per Monty Python, it's gone, ceased, no more, it's ex-data .... perhaps the "strings" CLI tool on a linux type machine ?)
Spurlash2
29th Jul 2011, 09:21
Which version of Excel?
If 2010, try this:
Open Excel 2010.
Click on File > Options.
Select Trust Center > Trust center settings.
Select Protected view.
Uncheck all the options under Protected View > OK.
Restart Excel 2010 and try to open Excel documents.
Thread HERE (http://answers.microsoft.com/en-us/office/forum/office_2010-excel/the-file-is-corrupt-and-cannot-be-opened-error-on/93af59c1-946c-4f5f-83c1-bd6f58dbd94f).
Good link HERE (http://www.wikihow.com/Recover-a-Corrupt-Excel-File).
Other Stuff.
Are you able to open it on another computer? Can you upload to Google docs and try from there?
aerobelly
29th Jul 2011, 21:01
Linux (or any other Unix) program "strings" will recover text fields, but not tell you which they were. It cannot recover numbers, formulae, or line/column data.
It might be worth trying a program that always has to take a guess about the internals of Microsoft's files, such as OpenOffice. But in the long run, the best solution to the problem of corrupted files is to take daily backups or use a plain-text storage that can be inspected and possibly repaired with a text editor, XML for example.
'b
mixture
30th Jul 2011, 09:50
aerobelly,
It cannot recover numbers
I suggest you run "man strings". A number was an ASCII char last time I checked.
Linux (or any other Unix) program "strings"... It cannot recover numbers, formulae, or line/column data.
The whole purpose of me suggesting it was as a last resort method, given that the file is corrupted he can't exactly expect a perfect recovery other than from backup ! You're lucky I didn't suggest he do a hexdump ! :cool:
If it's an XLSX document, try opening it with a ZIP reader program. (If you need one, I like 7-Zip Portable (http://portableapps.com/apps/utilities/7-zip_portable) for quick jobs.)
The XLSX document format is a set of XML documents inside a ZIP enclosure. If you can open it, navigate to subfolder xl/worksheets, and there's something there, you're in luck.