Though the migration from MS Office/Excel 2003 to Excel 2010 provides so many new features and functionalities to MS Excel, it is seen that people get the following error message when they (not always) try to open their .xls files:
"Excel found unreadable content in '[filename].xls'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."
Your Excel file may get opened after clicking 'yes', but there are chances of lost formatting, replacement of formulas with values, and other such inconsistencies. Moreover, this error is often followed by various other errors when you click 'Yes'. Whatever the situation is, the final output is the same, i.e. you are unable to access anything stored in your Excel sheet.
Causes: The most probable cause of encountering this error message is corruption of complete Excel file or corruption of one or more object in this file.
Resolutions: You can try any of the below mentioned resolution methods in order to resolve this error message:
Try to open your '.xls' file by making it 'read-only'. (Follow below procedure to make document 'Read-Only'):
'Navigate to 'Control Panel >> Programs' -> select Microsoft Office 2010, and then click 'Change >> Add or Remove Programs' -> at the bottom of this list, click the 'plus' sign provided next to Office Shared Features -> click Visual Basic for Applications -> After that, right-click and choose Run from My Computer -> click Continue'.
Reboot your system when this process finishes.
However, it is possible that all the above-mentioned resolutions fail. In such situations, use of Stellar Repair for Excel is recommended. This utility repairs corrupt MS Excel sheets without modifying its original content and formatting. Therefore, if the above resolutions are unable to do any good to you, then use of Excel recovery software is the best way to overcome data loss.
Follow below steps to repair corrupt Excel file with Stellar Repair for Excel software:
If you are satisfied with the preview result, then click on the ‘Repair’ button to start repair process.