Formatting and data loss when migrating from Excel 2003 to 2007
 

I am trying to open an excel file created in Excel 2003 into Excel 2007. I
get the errors listed below and i loose all formating on the text. There have
been instance where i have lost some lines of data from the excel file.

Is there any solution/bug fix for this problem? Attached is a copy of the
error log generated.

Regards
Swapnil D.



<?xml version="1.0" encoding="UTF-8" standalone="yes" ?
- <recoveryLog
xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"
<logFileNameerror037160_01.xml</logFileName
<summaryErrors were detected in file 'E:\091307-WIP.xlsx'</summary
- <removedRecords summary="Following is a list of removed records:"
<removedRecordRemoved Records: Style from /xl/styles.xml part
(Styles)</removedRecord
</removedRecords
- <repairedRecords summary="Following is a list of repairs:"
<repairedRecordRepaired Records: Format from /xl/styles.xml part
(Styles)</repairedRecord
<repairedRecordRepaired Records: Column information from
/xl/worksheets/sheet1.xml part</repairedRecord
<repairedRecordRepaired Records: Cell information from
/xl/worksheets/sheet9.xml part</repairedRecord
<repairedRecordRepaired Records: Cell information from
/xl/worksheets/sheet12.xml part</repairedRecord
<repairedRecordRepaired Records: Column information from
/xl/worksheets/sheet12.xml part</repairedRecord
<repairedRecordRepaired Records: Cell information from
/xl/worksheets/sheet13.xml part</repairedRecord
<repairedRecordRepaired Records: Column information from
/xl/worksheets/sheet13.xml part</repairedRecord
<repairedRecordRepaired Records: Cell information from
/xl/worksheets/sheet14.xml part</repairedRecord
<repairedRecordRepaired Records: Column information from
/xl/worksheets/sheet14.xml part</repairedRecord
<repairedRecordRepaired Records: Cell information from
/xl/worksheets/sheet15.xml part</repairedRecord
<repairedRecordRepaired Records: Column information from
/xl/worksheets/sheet15.xml part</repairedRecord
<repairedRecordRepaired Records: Cell information from
/xl/worksheets/sheet16.xml part</repairedRecord
<repairedRecordRepaired Records: Column information from
/xl/worksheets/sheet16.xml part</repairedRecord
</repairedRecords
</recoveryLog

Formatting and data loss when migrating from Excel 2003 to 2007
 

Did you get anywhere with this issue? I'm experiencing a very similar problem
and cannot find a resolution currently.

" wrote:

I am trying to open an excel file created in Excel 2003 into Excel 2007. I
get the errors listed below and i loose all formating on the text. There have
been instance where i have lost some lines of data from the excel file.

Is there any solution/bug fix for this problem? Attached is a copy of the
error log generated.

Regards
Swapnil D.



<?xml version="1.0" encoding="UTF-8" standalone="yes" ?
- <recoveryLog
xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"
<logFileNameerror037160_01.xml</logFileName
<summaryErrors were detected in file 'E:\091307-WIP.xlsx'</summary
- <removedRecords summary="Following is a list of removed records:"
<removedRecordRemoved Records: Style from /xl/styles.xml part
(Styles)</removedRecord
</removedRecords
- <repairedRecords summary="Following is a list of repairs:"
<repairedRecordRepaired Records: Format from /xl/styles.xml part
(Styles)</repairedRecord
<repairedRecordRepaired Records: Column information from
/xl/worksheets/sheet1.xml part</repairedRecord
<repairedRecordRepaired Records: Cell information from
/xl/worksheets/sheet9.xml part</repairedRecord
<repairedRecordRepaired Records: Cell information from
/xl/worksheets/sheet12.xml part</repairedRecord
<repairedRecordRepaired Records: Column information from
/xl/worksheets/sheet12.xml part</repairedRecord
<repairedRecordRepaired Records: Cell information from
/xl/worksheets/sheet13.xml part</repairedRecord
<repairedRecordRepaired Records: Column information from
/xl/worksheets/sheet13.xml part</repairedRecord
<repairedRecordRepaired Records: Cell information from
/xl/worksheets/sheet14.xml part</repairedRecord
<repairedRecordRepaired Records: Column information from
/xl/worksheets/sheet14.xml part</repairedRecord
<repairedRecordRepaired Records: Cell information from
/xl/worksheets/sheet15.xml part</repairedRecord
<repairedRecordRepaired Records: Column information from
/xl/worksheets/sheet15.xml part</repairedRecord
<repairedRecordRepaired Records: Cell information from
/xl/worksheets/sheet16.xml part</repairedRecord
<repairedRecordRepaired Records: Column information from
/xl/worksheets/sheet16.xml part</repairedRecord
</repairedRecords
</recoveryLog