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
