98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2010
Excel 2010
Resolved · High Priority · Version 2010
Dhiresh has attended:
Excel Intermediate course
Excel 2010
Hello Andrew,
Nice meeting you last week at TMC training.
Here is the problem I showed you.
When we open the sheet we get the following error
"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."
When we say no and then when we open it again it's fine.
I re-created by copying and pasting the data from scratch and it had the same issue.
Please Advise.
Regards
Dhiresh
RE: Excel 2010
Hi Dhiresh
Great to hear from you and thank you for posting the question. Just to double check does the file contain any VBA code at all?
I've taken a look and found an interesting support article that discusses recovering Excel spreadsheets that may have become corrupt. The article is here
http://social.technet.microsoft.com/Forums/office/en-US/83907359-df5d-42ff-8f2b-a298e49adc61/error-quotexcel-found-unreadable-content-in-filenamexls-do-you-want-to-recover-the-contents-of?forum=excel
with advice towards the bottom. Essentially they ask you to save the file out in .html format then re open in Excel. This format will drop out whatever is causing the corruption. it will very likely also lose formatting etc so the file may need tidying up afterwards. Best to test with a backup copy first!
The second article I found involved renaming a .dll file. It is hosted on Technet so I would say the approach is plausible but of course exercise caution when renaming operating files. It refers to Excel 2007 and I know you have 2010. I wondered if this issue may arise where 2010 and 2013 are accessing the same file. I have included the link below for information in case the first approach does not work.
http://blogs.technet.com/b/emeaoffice/archive/2012/11/29/you-may-receive-quot-unreadable-content-quot-when-opening-files-from-within-excel-2007-if-you-have-a-shellstreams-dll-file.aspx
Let me know how you get on.
Kind regards,
Andrew
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Switch on smart tags – Excel 2007In order to use smart tags, make sure they are turned on, to do this: |