Corrupted Excel File
Thread Starter
Joined: Aug 2000
Posts: 2,681
Likes: 10
From: Just South of the last ice sheet
Corrupted Excel File
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?
Does anybody have any recommendations on how to at least access the data?
Joined: Aug 2002
Posts: 3,663
Likes: 0
From: Earth
Restore off your latest backup. 
(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 ?)
(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 ?)
Joined: Apr 2005
Posts: 366
Likes: 0
From: Earth
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.
Good link HERE.
Other Stuff.
Are you able to open it on another computer? Can you upload to Google docs and try from there?
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.
Good link HERE.
Other Stuff.
Are you able to open it on another computer? Can you upload to Google docs and try from there?
Last edited by Spurlash2; 29th July 2011 at 09:46.
Joined: Nov 2002
Posts: 171
Likes: 6
From: Tapping the Decca, wondering why it's not working.
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
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
Joined: Aug 2002
Posts: 3,663
Likes: 0
From: Earth
aerobelly,
I suggest you run "man strings". A number was an ASCII char last time I checked.
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 ! 
It cannot recover numbers
Linux (or any other Unix) program "strings"... It cannot recover numbers, formulae, or line/column data.
Joined: Feb 2007
Posts: 755
Likes: 26
From: Dublin, Ireland. (No, I just live here.)
If it's an XLSX document, try opening it with a ZIP reader program. (If you need one, I like 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.
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.
