Excel Worksheet and backups suddenly get Unreadable Content Message

Try the following, select all workscheets and move or copy in new workbook.

Seems to have resolve the problem for one of my excels.

Having the same issue, though my spreadsheet does not have any comments--just lots of shapes (many of which are transparent). It took me hours to create this sheet, so this is immensely frustrating. Especially since I have no way of knowing that it won't just get corrupted again if I re-do all my hours of work.

I have the same problem with a large spreadsheet. I narrowed it down to 2 lines of data. If I delete either line of the date then when re-opening the file the problem appears. If I open it and allow Excel to do the "repair" by deleting the vmlDrawing1.vml part  all the comments are no longer there. I also cannot copy just the lines of data that are not the problem ones. If I just copy the other lines into a new Worksheet then save and re-open the file again then on the new Worksheet the problem now occurs. The first Worksheet is still OK because it has the offending lines still in it. I note that the second Worksheet has  vmlDrawing2.vml   removed and a third Workdheet has vmlDrawing3.vml removed when Excel does the "repair". Is there someone cleverer than me who would like to receive a copy of this file and have a look at it to see if they can work out why this is happening? I can send a version that has a few columns with comments, one cell with a picture comment, and only 5 lines of data. the file is about 700kB in size. ******@telstra.com.au.

The problem seems to persist in Excel.  Including pictures within comments works 90% of the time but every so often, one of the many files we use here will suddenly crump saying that Excel found 'unreadable content' and the comments are all dumped from the worksheet.

This sounds related to all the post's above, but here is the exact error report:

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

**-**<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

<logFileName>error064800_01.xml</logFileName>

<summary>Errors were detected in file 'C:\Documents and Settings\sa224c\Desktop\Conversion Files\Misc_Fcst_Actuals.xlsm'</summary>

**-**<removedParts summary="Following is a list of removed parts:">

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

</removedParts>

</recoveryLog>

.

Any help that can be offerred on this subject would be appreciated.  Unfortunately, I also use Excel 2007 features, i.e. rolling back to 2003 is not an option, and we have dozens of these files in use that cannot be re-created weekly every time this function corrupts.  It appears that this issue was first noted in 2011, so I would expect that someone has found a reasonable solution or cause for the problem.

Thanks in advance.