Excel Worksheet and backups suddenly get Unreadable Content Message

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>

I am having a related but somewhat different problem.  Every file I create with Excel 2010 is corrupt, and crashes after a few minutes of work.  When I try "Open and Repair", i get the following error message:

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

-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error342240_01.xml</logFileName><summary>Errors were detected in file 'C:\Users\BlueMonk\test1.xlsx'</summary>-<additionalInfo><info>Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.</info></additionalInfo></recoveryLog>

*EVERY* file i try to work with has the same problem.  Please help.

It appears that many of us are getting the same error with no resolution yet.  i have recently found that a form I am writing has also got the same error.  I have gone through step by step and found the trigger in mine, maybe this will help others in finding the resolution.

The form has checkbox controls which hide/unhide and named range upon selection.

Steps followed:

Create main template

Name Range 'PassApps'

Insert Control 'Check Box1'

Apply code to hide/unhide (codes below)

Check if working.

If the file is saved when the rows are unhidden - no problems

If the file is saved with any of the named ranges hidden - corruption occurs

If the file is saved with rows that are not a named range or only part of a named range hidden - no problems

(The named ranges are not the issues as the corruption occurs when the rows are called out in place of the named range)

CODE:

Sub ShowPassApps()

    Range("PassAPPS").Select

    Selection.EntireRow.Hidden = False

    Range("A78").Select

End Sub

Sub HidePassApps()

    Range("PassApps").Select

    Selection.EntireRow.Hidden = True

    Range("A78").Select

End Sub

Private Sub CheckBox2_Click()

 Run IIf(CheckBox2, "ShowPassApps", "HidePassApps")

End Sub

When the file re-opens with the corruption, all of the Checkboxes have been removed as part of the repair.

As with everyone else on this string, help wuold be very much appreciated

Hey BKayNJ,

I had this issue too and didn't know what was causing it - It was frustrating because all that work was gone and it happened to me twice already.

Were you working on multiple worksheets?

My guess is that you were....

If you are - one or more of the worksheet is bugged.  If you aren't then that worksheet that you are working on is bugged and you need to recreate the file again on a clean excel.

Here is how I was able to reproduce the error, find the worksheet that was bugged and was able to fix it

1. Open the file and that error will appear after you click "yes" ("Excel found unreadable content in..."  and it offered me to "recover the contents of this workbook".)
2. Re-Save that file after closing the error message (under another file name if you want).
3. Open that new file and that error message shouldn't appear

IF IT THE ERROR MESSAGE DOESN'T APPEAR

4. Select one worksheet and have that as your main and control variable
5. Copy an existing picture comment and paste it to "ONE" of the other worksheet
6. Save the file again (in another file name if you choose to)
7. Open it up again and if you see the error - that is the worksheet where the bug is located.  BUT if you DON'T see the error then that mean that the worksheet is not bugged.
8. If you don't see the error - keep repeating the steps from 4 to 7 until you open the workbook and experience that error.
9. If you didn't happen to find it then it could be that the worksheet that you selected as your control and main (where you copy the picture comment from) is the one that is bugged.

The way I fixed it was removing that worksheet from the workbook and creating a whole new one in a clean excel then merging them together.

I hope this helps but I was facing the same problem and error but was able to reproduce my error and knew what was causing mine.

Good Luck everyone

• JOHN 7L

I realize this post is a couple years old but it seems active and I did not see an answer. Setting the shape to the default properties before removing the comment seems to work for me.

With Selection

.Comment.Shape.SetShapesDefaultProperties

.ClearComments

End With

It is a mega frustrating problem which I waisted a lot of time, rebuilding the spreadsheets only

to have the same problem. This is unresolved for a couple of years now.

I eventually abandoned the project.

I don't have confidence in new Microsoft software, You pay for ms office and its bugged.

Even a long lived prog such as Ms Paint is now an unstable piece of software. I give up with MSoft.

Open office is free.