ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Unreadable Content Errors (https://www.excelbanter.com/excel-programming/431745-unreadable-content-errors.html)

Jday

Unreadable Content Errors
 
After running a series of macros in an Excel 2007 worksheet, then saving the
file & reopening, I get an error that tells me I have 'unreadable content'.
It allows me to open if I 'fix' the file, and then shows me the following
error log:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?
- <recoveryLog
xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"
<logFileNameerror006920_21.xml</logFileName
<summaryErrors were detected in file 'C:\Documents and
Settings\zjv0008\My Documents\Excel\Post Promotion Eval\PPE Scorecard
Template 072909 delete.xlsm'</summary
- <removedRecords summary="Following is a list of removed records:"
<removedRecordRemoved Records: Sorting from /xl/worksheets/sheet3.xml
part</removedRecord
</removedRecords
</recoveryLog

If I save the file after the 'fix', then reopen the file again, it is fine.
I cannot see anything different about the file after the 'fix' occurs, and so
far everything appears to work as expected, but I am in the build phase of
this file & it contains many sheet tabs & formulas. I am concerned about
integrity, but have no idea where to begin to look for the problem. I do not
want to rebuild everything, but would like any ideas on how to best isolate
the issue so I can try to put in a permanent fix. Any suggestions would be
much appreciated!!

[email protected]

Unreadable Content Errors
 
El miércoles, 29 de julio de 2009 11:30:01 UTC-6, jday escribió:
After running a series of macros in an Excel 2007 worksheet, then saving the
file & reopening, I get an error that tells me I have 'unreadable content'.
It allows me to open if I 'fix' the file, and then shows me the following
error log:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?
- <recoveryLog
xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"
<logFileNameerror006920_21.xml</logFileName
<summaryErrors were detected in file 'C:\Documents and
Settings\zjv0008\My Documents\Excel\Post Promotion Eval\PPE Scorecard
Template 072909 delete.xlsm'</summary
- <removedRecords summary="Following is a list of removed records:"
<removedRecordRemoved Records: Sorting from /xl/worksheets/sheet3.xml
part</removedRecord
</removedRecords
</recoveryLog

If I save the file after the 'fix', then reopen the file again, it is fine.
I cannot see anything different about the file after the 'fix' occurs, and so
far everything appears to work as expected, but I am in the build phase of
this file & it contains many sheet tabs & formulas. I am concerned about
integrity, but have no idea where to begin to look for the problem. I do not
want to rebuild everything, but would like any ideas on how to best isolate
the issue so I can try to put in a permanent fix. Any suggestions would be
much appreciated!!



mmmmm... no se


All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com