Excel Worksheet and backups suddenly get Unreadable Content Message

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.

Thanks dlauzon that was exactly what I needed. I created a vbs to clean up my VML file since it was pretty extensive, and here it is in case it helps anyone else:

' drag and drop the .vml file onto this script, new file is saved to the same location with a Fixed_ prefix

' bring in drag and dropped file

Set objArgs = WScript.Arguments

Set oFSO = CreateObject("Scripting.FileSystemObject")

Set oFSO2 = CreateObject("Scripting.FileSystemObject")

sFile = objArgs(0)

Set fileinfo = oFSO.GetFile(sFile)

' create new file

sFile2 = fileinfo.parentFolder & "\Fixed_" & fileInfo.name

If oFSO.FileExists(sFile) Then

 Set oFile2 = oFSO2.CreateTextFile(sFile2)

 Set oFile = oFSO.OpenTextFile(sFile, 1)

  Do While Not oFile.AtEndOfStream

   ' read through input file one line at a time

   sText = oFile.ReadLine

   IStartPos = 0

   iStartPos = InStr(sText, "o:relid=")

   ' if an o:relid is found we do special processing

   If iStartPos > 0 Then

    ' keep appending lines from the input file until we reach o:title

    iTitlePos = InStr(sText, "o:title=")

    While iTitlePos = 0

     sText = sText & oFile.ReadLine

     iTitlePos = InStr(sText, "o:title=")

    Wend

    ' find the LAST o:relid if there are more than one

    iNextPos = InStrRev(sText, "o:relid=")

    If iNextPos > 0 and iNextPos > iStartPos Then

     ' this is the last o:relid

     sItem = Mid(sText, iNextPos, iTitlePos - iNextPos)

     ' replace the multiple o:relid with only the last one

     sText = Left(sText, iStartPos - 1) & sItem & Mid(sText, iTitlePos)

    End If

   End If

   oFile2.WriteLine(sText)

  Loop

 oFile.Close

 WScript.Echo "Done"

End If

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.

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.

****< 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.