When opening an Excel spreadsheet in MS Office 2010/2007, you may get the following error message:
"Excel found unreadable content in '[filename].xlsx'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."
On clicking ‘Yes’, you may face any of these scenarios:
Note: If you choose to click 'No', then open your MS Excel application and click file > Open. When the Open dialog box opens, browse and select the file showing the 'Excel found unreadable content' error and then choose 'Open and Repair' option. If this didn't help, try using a third-party Excel repair tool to save time troubleshooting the issue and restoring the file with all its data intact.
Scenario 1: The following message may pop-up.
"Excel was able to open the file by repairing or removing the unreadable content. Excel recovered your formulas and cell values, but some data may have been lost. Click to view log file listing repairs errorxxx.xml."
The message clearly states that your Excel file might open, but images may be lost and other such inconsistencies can crop up.
Scenario 2: The error is followed by another error message, like “The file is corrupt and cannot be opened”.
What Causes ‘Excel Unreadable Content’ Error?
You may encounter the ‘Excel file unreadable content’ error due to corruption of complete Excel file or corruption in certain areas (like Pivot Table, Formulas, Styles, or other objects) in the file. According to Microsoft, you may find it difficult to determine the root cause behind Excel file corruption. Corruption could occur in different scenarios, like power surge, a network glitch, copying and pasting corrupted data from another file, etc.
Workarounds to Resolve the ‘Excel found unreadable content in filename.xls’ Error
There is no permanent solution to fix the ‘Excel found unreadable content’ error. But, following are some workarounds you can try to resolve the error.
Note: Before you try any of these workarounds, run Excel with administrator privileges and try opening the Excel file that is throwing the ‘unreadable content’ error. If this doesn’t fix the error, proceed with the workarounds below.
Workaround 1 – Try Opening the File in Excel 2003
Sometimes a problem in the current Excel version might prevent a file from opening. To resolve this error, try opening the problematic file in Excel 2003. If the file opens, save the data in a web page file format (.html) and then try opening the .html file in MS Excel 2010/2007. The detailed step-wise instructions are as follows:
- Open the .xls file in Excel 2003.
- When the file opens, click on File > Save.
- In the ‘Save As' dialog box, choose Web Page (.html) as the 'Save as type' and then click 'Save.' Doing so will save everything from your .xls file, opened with 2003, in .html file format.
- Open the .html file in Excel 2010/2007. And then, save the file with .xlsx extension with a new name to avoid overwriting the original file.
Now, open the Excel 2010/2007 file and check if the error is fixed. If not, use the next workaround.
Workaround 2 – Make the Excel File ‘Read-only’
Try to open your '.xlsx' file by making it 'read-only'. Follow these steps:
- In Excel, click ‘File’ from the main menu.
- Select 'Save' for a new document or 'Save As' for a previously saved document in the screen that appears.
- From the ‘Save As’ dialog box, click Tools > General Options.
- Click on the ‘Read-only recommended’ checkbox to make the document read-only and then click ‘OK’.
Now open a new '.xlsx' file and copy everything from the corrupt Excel file to this new file. Finally, save this file and try to open it again.
Workaround 3 – Move Excel File to a New Folder
Some users have reported that they could open their Excel file, following the ‘Excel unreadable content’ error, by simply moving the file to a different folder and saving it under a new name. You can also move the affected file to a new folder and try opening it. If this didn’t help resolve the error, follow the next workaround.
Workaround 4 – Install Visual Basic Component
At times, it is seen that installing the 'Visual Basic' component of MS Office 2010 resolves the ‘Excel found unreadable content 2010’ error. To do so, follow these steps:
- Navigate to Control Panel > Programs and select Microsoft Office 2010.
- Click ‘Change’ and then select ‘Add or Remove Programs’.
- Next, 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’ and hit the ‘Continue’ button.
- Reboot your system when this process finishes.
Now check if the issue has been resolved or not.
If none of the workarounds mentioned above works for you, use a professional Excel repair software, such as Stellar Repair for Excel. The software repairs corrupt MS Excel sheets without modifying their original content and formatting. In addition, it can repair single or multiple Excel (XLS/XLSX) files in a few simple steps.
Steps to Repair Corrupt Excel File using Stellar Repair for Excel Software
- Install and run Stellar Repair for Excel software.
- From the software main interface window, click ‘Browse’ to select the corrupt file. If you are not aware of the corrupt Excel file location, click on the ‘Search’ button.
- Click on the ‘Repair’ button to scan and repair the selected file.
- A preview window will open with recoverable Excel file data. Once satisfied with the preview result, click on the ‘Save File’ button on the ‘File’ menu to start the repair process.
- Select the destination to save the file.
- Click ‘OK’ when the ‘Repaired file saved successfully’ message appears.
The repaired Excel file will get saved at the selected location.
Q. I have the same problem. It appeared suddenly and only for two Excel files.
I open my file without any problem in the morning. I copy paste some new data and then save it, as I always did before. Now if I want to re-open the file, I am getting this error message:
"Excel found unreadable content in 'TEMP_XXX_2014_03.xls' (name of my file). Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."
I clicked on Yes and another message appeared, 'the file is repaired, but some data may be lost.' When I open the file, some of the data is indeed missing. The formulas are lost. I need to restore the file without losing any formulas. Please suggest what I can do.
A. Try using Stellar Repair for Excel software to restore the file and recover all its components, including Formulas, Pivot Table, Charts, Cell References, etc.
Q. How can I ensure that the Excel repair software can help recover the spreadsheet data?
A. You can download the demo version of Stellar Repair for Excel software. The demo version allows to select a corrupt Excel file (.xls and .xlsx), repairs it, and then displays a preview of all the recoverable data.