excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2010

Excel 2010

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Switch on smart tags – Excel 2007

In order to use smart tags, make sure they are turned on, to do this:
1. Click on ‘Microsoft Office‘ button and then click on ‘Excel Options‘.
2. Click on ‘Proofing‘ category and then click on ‘Auto Correct Options‘.
3. In the ‘Auto Correct‘ dialogue box appears, click the ‘Smart Tags‘ Tab.
4. Tick the boxes, next to the Smart Tags you wish to use in Excel

View all Excel hints and tips


Server loaded in 0.07 secs.