Unreadable Content Excel 2007

[canman1878]

I am working on an excel spreadsheet which has a large amounts of arrow (using the excel drawing tools). To open the file excel needs to remove the drawings tool images I have used. This sounds trivial but they are an important part o my document. I am using excel 2007 and windows 7

1) can anyone suggest how to repair the file without losing original content
2) can anyone suggest a mehtod to prevent this happening again if I re-input the drawing tool images

Thanks Gordon

Please see additional information below

>>>I have used drawing tools in excel 2007 (colored arrows). When I opened the excel spread sheet I received the following message:
"Excel found unreadable content in 'File Name'. Do you want to recover the contents of the workbook? If you trust this source, click yes."

>>>After I click yes I received the following message box :
Excel was able to open the file by repairing or removing the unreadable content
"Removed Part: /xl/drawings/drawing1.xml part. (Drawing shape)"

>>>After I clicked on the hyperlink: Click to view log file listing repairs
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error036400_01.xml</logFileName>

<summary>Errors were detected in file 'File name'</summary>

- <removedParts summary="Following is a list of removed parts:">
<removedPart>Removed Part: /xl/drawings/drawing1.xml part. (Drawing shape)</removedPart>

</removedParts>


</recoveryLog>

>>> This results in all of the arrows I have used in my file to be removed

 

[Tyron]

Hey canman1878,

I encountered a similiar situation with Excel 2013 where I had hundreds of lines that interconnected information. I could not resolve the issue and ended up resorting to changing to "XXX" over the span of three cells. Although it is a bit primitive it currently acts a band-aid for the moment. I will definitely follow this thread in the hopes that one of the more experienced users can help solve this problem and maybe explain why this happens.
My only guess is that it is hogging memory loading all of the objects to the extent that it crashes the workbook.

later

Ty