Excel Worksheet and backups suddenly get Unreadable Content Message

I have a 400 line Excel 2007 single worksheet spreadsheet.
Each row has a Comment inserted in one of the cells. The Comment has been formatted as follows: "Size" has been adjusted, "Colors and Lines" has been adjusted by choosing "Color", "Fill Effects", "Picture", "Select Picture" and a .jpg file from a certain folder is selected.
The result is that when I hover over this cell in any given row, the .jpg file that was placed in the Comment appears.  There are other simple text comments in several other cells in the worksheet.
This all was working fine for me for several months, and I was making backups just to be safe.
Suddenly, I started getting "Excel found unreadable content in..."  and it offered me to "recover the contents of this workbook". When I choose to recover, I get my entire worksheet back without any comments (ones with .jpgs and ones without), and I am told "Excel was able to open the file by repairing or removing the unreadable content".
I also get a chance to view the "log file" and this is its contents:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
  <logFileName>error053200_01.xml</logFileName>
  <summary>Errors were detected in file 'C:\Users\Bruce Kay\Desktop\Documents\DOCUMENTS ON iPhone\All Casino Chip Collection.xlsx'</summary>
- <removedParts summary="Following is a list of removed parts:">
  <removedPart>Removed Part: /xl/drawings/vmlDrawing1.vml part. (Drawing shape)</removedPart>
  </removedParts>
  </recoveryLog>
 The same thing happens with all of my backups of this sheet, and those were backups of working versions of this sheet.
This is all unbelievably frustrating.
Does anyone think this was due to an automatic update by Microsoft?
Do you have any suggestions for recovery?
Thanks
 

Question Info


Last updated January 14, 2020 Views 30,900 Applies to: Have the experts at Excelchat fix your formulas for free. See how.

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

  < removedPart > Removed Part: /xl/drawings/vmlDrawing1.vml part. (Drawing shape ) </ removedPart >
  </ removedParts >
 
 

As the recovery log suggests, the issue might be with the picture/ Drawing type that you are trying to insert, My best bet is to recreate the worksheet as the issue seems to be with the sheet which is corrupted by the drawings, I tried searching for an answer on the net and most of them suggested to recreate the worksheet, it is difficult to predict until we reproduce the same issue. Perhaps if you can share the workbook, I can have a look at it or the other community users who visit might try different things to resolve your issue

SOLUTION : Recreate the sheet :)

BLACK BARRON


P.S : Please post back with the status of the issue. If this post was helpful to you, please vote for my post If this post has helped you resolve your issue, please mark my post as answered.

3 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Black Barron, thanks for taking time to respond and thanks for your suggestion

This is what I'm trying to avoid - recreating the sheet by having to manually insert the .jpg files into Comments - a real pain.

Actually, this happened once before (months ago) and that's what I had to do. Now it happened again, and if I spend the time to fix it, I fear it could just happen a 3rd time some day.

Also, all the comments I had that did not have a .jpg inserted are not recreatable.

What frustrates me, is that by virtue of the size of the file before I tell Excel to "recover" seems to be the size that has all the .jpg information still in there, whereas after it recovers the file, discarding the "so-called" unreadable part, the file is MUCH smaller, but has every cell filled with the correct data except for all the Comments that had .jpgs in it or not.

Taking another approach, and I don't have the talent to do this myself, one cell in each row has the name of the jpg file (without the path and the ".jpg" extension) of the image I want to insert into the comment in another cell in that row.  If I could automate this process, the recreation of this spreadsheet would not be so daunting (though I'd still not be able to recover any of the comments that were just text comments - but I'd live with that). I've tried recording a Macro while going through the process, but was unsuccessful. I've set up the column that would contain the images with a blank comment in each cell adjusted to the proper size.  So all I need to automate (after selecting the cell to work on) is:

Right-Click

choose Edit Comment

Right-Click (within the crosshatches)

choose Format Comment

click Colors and Lines

click Color

click Fill Effects

click Picture

click Select Picture (it remembers the most recent path to where my .jpgs are)

type in the file name (which is in another cell on the same row in my spreadsheet) and add ".jpg"

Return

click OK

click OK

and I'm done - move onto the next cell in that column and repeat

 

Can I somehow automate that?

Otherwise, I'd be glad to share the workbook. How do I get it to you? I don't see where I can attach it in here.

Thank you and anybody else so much for looking at this.

 

 

 

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I am having a similar issue (see error message below). I re-created the excel sheet from scratch and halfway through I closed the file and started getting the error message again. I need urgent help on this issue. Are there any tools we can use to fix this?

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>

- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
  <logFileName>error052800_01.xml</logFileName>
  <summary>Errors were detected in file 'C:\Users\Johannao\Documents\Finance\2010\JOH_Budget_2010.xlsx'</summary>
- <removedParts summary="Following is a list of removed parts:">
  <removedPart>Removed Part: /xl/drawings/drawing2.xml part. (Drawing shape)</removedPart>
  </removedParts>
  </recoveryLog>

89 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I have got the error msg. in Excel 2010

8 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Office Version:Excel 2007

Operating System:Windows 7 (on x86)

I have macros that are used to link values from mulltiple sheets to one "exchange file" that holds values between all the other sheets. I get a similar error to that above when trying to call the "exchange file".

However...

Office Version:Excel 2007

Operating System:Vista (on x86)

I do not get any error, and my macros work fine. The macros were initially created in Excel using a Vista machine and then a second set of similar spreadsheets (with the same macros) were created using a Windows 7 machine.

Could it be a Windows 7 and Excel 2007 problem?

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I have a similar problem.  I have a web application that allows users to save docs to a NAS server.  The users can save 2007 docs and spreadsheets, but when they try to open them from the application they get the same error you show above.  It happens to all spreadsheets regardless of what the spreadsheet contains. 

3 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

i am getting exactly the same problem

: /xl/drawings/vmlDrawing1.vml part is removed.

created a huge spreadsheet and its now corrupt

should send microsoft the bill for the hours spent on it.

Frustrating is an understatement.

recreate the sheet is not a solution...confidence in microsoft software hugely dented again.

5 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I faced same problem today as well.
Had pictures in the comment field
Now Excel 2010 tells me

"Excel found unreadable content .... "

Excel was able to open the file by repairing or removing the unreadable content
Removed Part: /xl/drawings/vmlDrawing1.vml part.  (Drawing shape)"

The pictures are gone !!!

Have you found a fix other than recreating the sheet.

Thanks
Ashiq




Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I have the same, and found a workaround.

It appears to be caused by deleting a picture comment.  It deletes it fine, saves and closes excel correctly, but on re-opening, the error appears.

I'm on Windows XP, Office 2007.  I was able to get the original document back from before the so called "repair", from a backup tape.  If I backsaved it to the old Excel format (Excel 97-2003) I don't experience the error again.

That wont help if you're using functions from Excel 2007 onwards, and you can't get the original file back, but saved me!

Andy.

2 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Am recieving the same error message when trying to open a workbook with pictures and sames pasted in certain cells.  The issue persists even when opening a backup version of the file from a date I am %100 certain the file was fine.

 

Am I really going to just put up with completely redoing a workbook every month or so?  This is the second workbook this has happened too, both are being used in similar ways.

 

Any more recent progress on this issues?

 

 

  -Brad

 

 

Below is error details...

 

 

  <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
  <logFileName>error045960_01.xml</logFileName>
  <summary>Errors were detected in file 'G:\Brad\WIP\SPID 2402 NORTHFIELD CHUCK.xlsx'</summary>
- <repairedRecords summary="Following is a list of repairs:">
  <repairedRecord>Repaired Records: Drawing from /xl/drawings/drawing1.xml part (Drawing shape)</repairedRecord>
  </repairedRecords>
  </recoveryLog>

13 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.