"Excel Found Unreadable Content" error

bill_ohio

New Member
Joined
Jun 14, 2005
Messages
31
My wife has a file that worked a week ago, and now gives the "Excel found unreadable content in Book_Name" error. Clicking "yes", opens the repaired file, but content has now changed.

The file contained over 50 cells in Column A that had a comment formatted to display a picture, instead of a message. All the comments have been removed. The explanation of the repairs is given in the following, which I do not understand:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error016400_01.xml</logFileName>
<summary>Errors were detected in file 'C:\Documents and Settings\Arlene\My Documents\Flora_Fauna_Dates_COPY.xlsx'</summary>
- <removedParts summary="Following is a list of removed parts:">
<removedPart>Removed Part: /xl/drawings/vmlDrawing1.vml part. (Drawing shape)</removedPart>
</removedParts>
- <removedRecords summary="Following is a list of removed records:">
<removedRecord>Removed Records: Comments from /xl/comments1.xml part (Comments)</removedRecord>
</removedRecords>
</recoveryLog>

Everything I have been able to find on any other message board, including Microsoft, points to an error with Pivot Tables, but this file doesn't have any.

I did find a hotfix on the Microsoft site (KB Article Number: 956836) that I am somewhat hesitant to use.

Any ideas? Does anyone need more information? My wife would greatly appreciate the assistance - this is way beyond me!

thanks in advance,

Bill
 

silkfire

Active Member
Joined
Apr 6, 2009
Messages
441
Try sending the file to me (removed) and I'll see what I can do.
Has the file been modified after being opened? Send me the unmodified file, even if opening it will strip it from the pictures in the comments.
 
Last edited by a moderator:

bill_ohio

New Member
Joined
Jun 14, 2005
Messages
31
Thanks! I'll send as soon as I quit here. The file was last saved April 6, when it worked fine. Each time we opened it today, we closed without saving.

Bill
 

silkfire

Active Member
Joined
Apr 6, 2009
Messages
441
Bill I just opened your document and I can state that all the images within the comments are still there, so what is the problem really?
 

bill_ohio

New Member
Joined
Jun 14, 2005
Messages
31
Gabriel,

I received your email before I checked here. There are no images in the first tab, "wildflowers", but there were on April 6.

thanks.
 

bill_ohio

New Member
Joined
Jun 14, 2005
Messages
31
NateO -

I'm reluctant to use the "hotfix" because I wasn't sure if all the specific situations applied directly to my situation. I didn't want to make a bad situation even worse. The hotfix was not recent, and I have downloaded all the critical updates that Microsoft sends out.

Bill
 

silkfire

Active Member
Joined
Apr 6, 2009
Messages
441
Bill does your wife still have the images on the harddrive? Or is it too tedious remaking the first sheet page?
 

bill_ohio

New Member
Joined
Jun 14, 2005
Messages
31
Gabriel,

The issue now is one of being a pain in the rear to rebuild, and the fear that the same thing may happen again. Since we don't really know what caused this, we're not sure what to do. (and, unfortunately, most of the images were found by searching the internet, and she didn't keep a copy)

thanks again,
Bill
 

silkfire

Active Member
Joined
Apr 6, 2009
Messages
441
She didn't keep a copy of them?

No problem, I have them here. I found 2 advanced XLSX repairing utilities online but they cost about $60 and I don't think it's worth the effort buying them, they are called Recovery Toolbox for Excel and Stellar Phoenix Excel Recovery.

 

Forum statistics

Threads
1,082,040
Messages
5,362,804
Members
400,693
Latest member
jenlj

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top