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

 

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

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

At times, it is seen that installing the 'Visual Basic' component of MS Office 2010 resolves the error message. Follow the below mentioned steps to do the same:

'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 professional Excel recovery software like Stellar Phoenix Excel Recovery is recommended. This professional 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 professional Excel recovery software is best way to overcome data loss. 

Was this article helpful?

Yes No

Category: Excel Repair

Last updated on July 17, 2013 with 119295 views

1 User Comments

Eric
March 26, 2014 08:55 am

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"

Leave a Comment













 

Stellar Phoenix & Stellar Data Recovery are Registered Trademarks of Stellar Information Technology Pvt. Ltd.
© Copyright 2014 Stellar Information Technology Pvt. Ltd. All Trademarks Acknowledged.