Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming,microsoft.public.xml,microsoft.public.excel
|
|||
|
|||
![]()
Hi,
I can reproduce this error but can get rid of it. I run my macros that places a number of lines etc onto a worksheet. If I save this workbook as a .xlsm file then resopen it - everything is fine. BUT - if I copy, via macro, a sheet from an old 2003 .xls file, then run the macros to build the lines etc and the workbook saved as a .xlsm file. Then when I reopen it, I get the following error message: Excel found unreadable content in '..........'. Do you want to recover the contents of this workbook? after pressing 'Yes' Removed part: /xl/frawings/drawing1.xml part. (Drawing shape). Copy of the error log is: <?xml version="1.0" encoding="UTF-8" standalone="yes"? <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/ 2006/main" <logFileNameerror004240_01.xml</logFileName <summaryErrors were detected in file 'C:\Gantt .........xlsm'</ summary <removedParts summary="Following is a list of removed parts:" <removedPartRemoved Part: /xl/drawings/drawing1.xml part. (Drawing shape)</removedPart </removedParts </recoveryLog (screenshot also available, if required) Then after I open, run the same macro to build the lines etc, save as .xlsm file, it opens OK. The error is reproduced if I fo the COPY again. If I just to the copy and save as .xlsm, the file opens OK. But if I then do the line build, save it fails again. I don't think the problem is in the macros that build the lines because after the first error, you can run the line builder macro and save as many times as you like without the error. Any help greatly appreciated. I can email copies of the files in various stages of bug production if that helps anyone. Cheers, Dennis. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 strange behavior on two computer | Excel Discussion (Misc queries) | |||
Strange Excel error | Excel Discussion (Misc queries) | |||
Excel 2007 (Beta) - strange behavior of macro | Excel Programming | |||
I am getting a strange round off error in excel | Excel Worksheet Functions | |||
Strange Calculation Error in Excel | Excel Discussion (Misc queries) |