stmoritz
asked on
Excel found unreadable content in ‘[filename].xls’. Do you want to recover the contents of this workbook?
I use Windows 7 64bit with Office 2010 32bit.
The move from Office/Excel 2003 to 2010 was just a few weeks ago. With 2003, I never had this problem, now I regularly get the following error message (it seems to me that this has happened only with .xls files yet, but I am not 100% sure):
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.
If I click Yes and open the respective file, all formattings have gone, and a large part of formulas are replaced with values and many errors appear. In simple words: The entire workbook is f..ked up and lost. However, often it is okay again as if nothing had happened when opening the exact same file again 30 or 60min subsequent to this incident.
Has anybody else also been confronted with this problem?
What are the reasons?
How can it be avoided?
Thanks a lot for your input and help!
Through googling I found this here:
Might this be the reason? Is this the most simple fix? Shall I have a go? Who has some personal experience?
There's also a MS hotfix that might solve it, but I can't find the actual links/URL to download these hotfix files: http://support.microsoft.c
Thanks!!!
The move from Office/Excel 2003 to 2010 was just a few weeks ago. With 2003, I never had this problem, now I regularly get the following error message (it seems to me that this has happened only with .xls files yet, but I am not 100% sure):
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.
If I click Yes and open the respective file, all formattings have gone, and a large part of formulas are replaced with values and many errors appear. In simple words: The entire workbook is f..ked up and lost. However, often it is okay again as if nothing had happened when opening the exact same file again 30 or 60min subsequent to this incident.
Has anybody else also been confronted with this problem?
What are the reasons?
How can it be avoided?
Thanks a lot for your input and help!
Through googling I found this here:
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.
Might this be the reason? Is this the most simple fix? Shall I have a go? Who has some personal experience?
There's also a MS hotfix that might solve it, but I can't find the actual links/URL to download these hotfix files: http://support.microsoft.c
Thanks!!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
One of the workbooks in question, to which it just happened today and caused me to ask this question, has basically no formatting just row 1 on every sheet that is formatted bold, so this can't be the reason I'd say. But it has some VBA code modules. Btw, now it is working again...
Perhaps running code cleaner by Rob Bovey helps removing the problematic content.
What did Excel report to have removed when it said it had to recover content?
What did Excel report to have removed when it said it had to recover content?
ASKER
@jkpieterse
:o) code cleaner already run...
@wasiftoor
thanks for the link. I will try to install it and watch whether during the next one or two weeks I won't be confronted with this issue anymore.
@all
stupid question, which version of the hotfix do I need to download and install, the x86 or x64? As my OS is Windows 64bit, this would imply x64, however as the Excel is from Office 2010 32bit, this would rather suggest the x86 version... x86?
:o) code cleaner already run...
@wasiftoor
thanks for the link. I will try to install it and watch whether during the next one or two weeks I won't be confronted with this issue anymore.
@all
stupid question, which version of the hotfix do I need to download and install, the x86 or x64? As my OS is Windows 64bit, this would imply x64, however as the Excel is from Office 2010 32bit, this would rather suggest the x86 version... x86?
ASKER
repost: [forgive me]
which version of the hotfix do I need to download and install, the x86 or x64? As my OS is Windows 64bit, this would imply x64, however as the Excel is from Office 2010 32bit, this would rather suggest the x86 version... x86?
which version of the hotfix do I need to download and install, the x86 or x64? As my OS is Windows 64bit, this would imply x64, however as the Excel is from Office 2010 32bit, this would rather suggest the x86 version... x86?
I think your windows version determines what you need to download.
Cleaning up excess formatting of those files usually resolves the problems.
There are some tools available that may help you with that task, but each tool aims at different aspects of the problematic content a file with a long editing history may have.
One way to find out whether your file may have a formatting issue is to do this:
- Open a blank workbook. On the home tab of the ribbon, click the cell styles gallery dropdown. Try to remember (roughly) what is there.
- Now open your problem workbook and do the same. Does the style dropdown contain many additional entries?