Repaired Records: Drawing from /xl/drawings/drawing9.xml part (Drawing shape)

[ajith]

Hello, Can somebody help me. I am getting this error message when I try to save the file. I tried to save the file as both macro enabled and as normal excel file. I got the following description in the log file. <?xml version="1.0" encoding="UTF-8" standalone="true"?> -<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error136720_01.xml</logFileName><summary>Errors were detected in file 'G:\Documents\BILL\pay\Mty\New folder\BILL HATCHER 2.2121.xlsm'</summary>-<repairedRecords summary="Following is a list of repairs:"><repairedRecord>Repaired Records: Drawing from /xl/drawings/drawing9.xml part (Drawing shape)</repairedRecord></repairedRecords></recoveryLog> I am not having any file with the name "drawing9.xml" but I have inserted some pictures (but earlier also). What I added recently to the workbook was a macro in a new sheet which converts numbers in a cell to different columns (Text to column). Please help me

 

[Andrew Poulsom]

Does your workbook have any shapes?

 

[ajith]

Does your workbook have any shapes?

Thank you for responding. Yes Sir. All these problem started after I pasted some arrow symbols. So I deleted all the symbols and tried to save but it was showing this error. So I deleted the entire file and added in an earlier version of the workbook, a new worksheet for "text to column". I did not use arrow symbols in this one. I was saving the file in between. Once I completed the work I have saved and exit. There after when I open the file I am getting this error message. Expecting suggestions.

 

[Andrew Poulsom]

I think the shape must still be there, but corrupted.

 

[ajith]

I think the shape must still be there, but corrupted.

Thank you sir for the response. As you have suggested in one worksheet the macro controls had disappeared and is not even in the hidden area. So I have deleted the entire worksheet and made a new one. There are 13 sheets it is difficult to go through all, especially when some are optional. Now it working perfectly. Thank you for reminding me.

 

[TalEngManagement]

Thank you sir. you have just saved my life.