Stellar Knowledge Base

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

 Modified on: October 15, 2020 |    521879 views

When trying to open an Excel spreadsheet in Office 2007/2010, you may come across 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 Unreadable Content Error

On clicking ‘Yes’, any of these scenarios may occur:

  • Your Excel file might open but formatting may be lost, formulas replaced with values, and other such inconsistencies can crop up.
  • The error is followed by another error message. For instance, you may encounter “The file is corrupt and cannot be opened” error message.

Quick Solution: If your Excel spreadsheet contains valuable data, we recommend you to use Stellar Repair for Excel software to restore your spreadsheet to its original, intact state. The software can repair multiple .xls/.xlsx files in just three simple steps. Download the free trial version of the software from the link below to validate its efficiency.

What Causes ‘Excel Unreadable Content’ Error?

You may encounter ‘Excel file unreadable content error’ due to corruption of complete Excel file or corruption of one or more objects in the file.

Workarounds to Fix ‘Excel Unreadable Content’ Error

Following are some workarounds you can try to resolve this error:

See thisHow to recover data from corrupt or damaged Excel file 2010 & 2007?

Workaround 1: 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.
  • In the screen that appears, select Save for new document or Save As for previously saved document.

Save and Save As Options

  • From the ‘Save As’ dialog box, click Tools > General Options.

General Options in Excel

  • Click on the ‘read-only’ checkbox to make the document read-only, and then click OK

Read Only Option

  • Open a new and blank '.xlsx' file and copy everything from the corrupt Excel file to this new file. Save this file and try to open it again.

Workaround 2: Move Excel File to a New Folder

Some users have reported that they were able to open their Excel file, following the ‘Excel unreadable content’ error, by simply moving the file to a different folder.

Workaround 3: 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 message. To do so, follow these steps:

  • Navigate to Control Panel > Programs > 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 above-mentioned workarounds work for you, using professional Excel repair software such as Stellar Repair for Excel can come in handy. The software repairs corrupt MS Excel sheets without modifying their original content and formatting. It can repair single or multiple Excel (XLS/XLSX) files in a few simple steps.

Steps to Repair Corrupt Excel File with 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 File menu to start 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.

 

7 User Comments

I have exactly the same problem - and it appeared suddenly and only for 2 excel files.
I open my file without any problem in the morning, I copy paste some new data then save... as I always did it before. Now if I want to re-open the file, I get an error message. What really weird is, is that one of my colleagues can open it... so he can save it under another name and send it back to me... and then, it works!!

It's a real pain in the*** as it now happens every day! I don't know why my colleague can read it and not me

to answer the previous question, no, it does not happen with all files.... and also, it used to work so far (I changed nothing)

the real message is: "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"

Eric

Pl solved

Dipak Dutta

I know this may not be an ideal solution, but I was able to fix exactly same error message by saving with other name.

Barbara

Tried it on numerous file and all so called repaired files show no data whatsoever

Michael Gallagher

Kartik

Hi,

We understand the inconvenience caused to you.

As per our records, our experts are assisting you on your email. Please reply to them in order to get resolve the issue.

Regards,

Stellar Data Recovery

The process seems to go on endlessly without actually ever coming to an end. Sat with a Microsoft Excel 97-2003 Worksheet (.xls) file for a very long time with no suceess at the end.

Dr Ruchir Mishra

Abdul Majid

Hi Dr. Ruchir,

We understand that software is taking long time to complete the repair process.

Please let us know the below details to analyze the situation:

1. Reason for the corruption of excel file.
2. Is this file getting copied to another location. In case file is not getting copied than there might be bad sectors in the drive.

 

User Comments


 

 

Stellar Repair for Excel Stellar Repair for Excel is the best choice for repairing corrupt or damaged Excel (.XLS/.XLSX) files. This Excel recovery software restores everything from corrupt file to a new blank Excel file.

Learn More

 

Related Articles