File Repair

How to Resolve 'Excel found unreadable content in filename.xlsx' Error in MS Excel?

Summary: Have you encountered the ‘Excel found unreadable content in filename.xlsx’ error? You may commonly receive this error when opening an Excel file in Office 2010 or 2007 version. This article discusses manual workarounds that can help you regain access to your Excel file and its data. For immediate access to the Excel file data, you can use Stellar Repair for Excel software. This article also covers how you can use the software to recover Excel files without any data loss quickly. Download the free version of the software from the link below to preview your recoverable workbook data.


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."

Excel Found Unreadable Content Error Message

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."

Excel Was Able To Open the File By Repairing Message

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.

Also ReadHow to recover data from corrupt or damaged Excel file 2010 & 2007?

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.
Excel File Saving Options
  • From the ‘Save As’ dialog box, click Tools > General Options.
Open General Options In Excel
  • Click on the ‘Read-only recommended’ checkbox to make the document read-only and then click ‘OK’. 
Select Read Only Recommended Option

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.

What Next?

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.

free-download

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.
Select Corrupt excel File
  • Click on the ‘Repair’ button to scan and repair the selected file.
Scan Corrupt Excel 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.
Preview Recoverable Excel File Data
  • Select the destination to save the file.
Save Repaired Excel File
  • Click ‘OK’ when the ‘Repaired file saved successfully’ message appears.
Saving Complete Message

 The repaired Excel file will get saved at the selected location.

FAQs

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.

74% of people found this article helpful