Excel found unreadable content in *******.xls. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click yes

I keep generating the following error message while opening an *.xls spreadsheet.... (Excel found unreadable content in *******.xls.  Do you want to recover the contents of this workbook?  If you trust the source of this workbook, click yes), then the next message comes up.... (Excel was able to open the file by repairing or removing the unreadable content). 

I tried reduping the problem to a different laptop, which is running Windows XP and running MS Office 2007.  However, I tried on a third laptop running Windows XP and running MS Office 2002.... no error messages were generated.

Please assist,

Javi

Answer
Answer

I have found a fix for this. Install the Visual Basic component in Office 2010. We haven't had the error since!

Control Panel > Programs > select Microsoft Office 2010 and click on Change > Add or Remove Programs > at the bottom of the list click on the plus next to Office Shared Features > select Visual Basic for Applications > I right clicked and chose Run from My computer > Continue. Reboot when it has finished.

624 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated November 2, 2024 Views 209,809 Applies to: