Excel found unreadable content in 'zzz.xlsx'

**konami** · 05-08-2013, 11:13 PM

hi, i need help regarding excel. I've google but have not found the answers to the problems I had.
my user have zzz.xlsx file, when i open it in excel 2007 it give me an error message

Excel found unreadable content in 'zzz.xlsx' Do you want to recover the contents of this workbook ? If you trust the source of this workbook, click Yes.

I choose yes, and then it show me another information. and here it is

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error030840_01.xml</logFileName>
<summary>Errors were detected in file 'C:\MyFile\zzz.xlsx'</summary>
- <removedRecords summary="Following is a list of removed records:">
<removedRecord>Removed Records: Style from /xl/styles.xml part (Styles)</removedRecord>
</removedRecords>
- <repairedRecords summary="Following is a list of repairs:">
<repairedRecord>Repaired Records: Format from /xl/styles.xml part (Styles)</repairedRecord>
</repairedRecords>
</recoveryLog>

I follow from another thread in excelforum, I zip zzz.xlsx file and see the content_types.xml

[Content_Types].xml, it content :

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Types xmlns="http://schemas.openxmlformats.org/package/2006/content-types"><Default Extension="bin" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.printerSettings"/><Override PartName="/xl/worksheets/sheet9.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"/><Override PartName="/xl/theme/theme1.xml" ContentType="application/vnd.openxmlformats-officedocument.theme+xml"/><Override PartName="/xl/styles.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml"/><Override PartName="/xl/worksheets/sheet6.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"/><Override PartName="/xl/worksheets/sheet7.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"/><Override PartName="/xl/worksheets/sheet8.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"/><Override PartName="/xl/worksheets/sheet11.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"/><Default Extension="rels" ContentType="application/vnd.openxmlformats-package.relationships+xml"/><Default Extension="xml" ContentType="application/xml"/><Override PartName="/xl/workbook.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml"/><Override PartName="/xl/worksheets/sheet4.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"/><Override PartName="/xl/worksheets/sheet5.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"/><Override PartName="/xl/worksheets/sheet10.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"/><Override PartName="/docProps/app.xml" ContentType="application/vnd.openxmlformats-officedocument.extended-properties+xml"/><Override PartName="/xl/worksheets/sheet2.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"/><Override PartName="/xl/worksheets/sheet3.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"/><Override PartName="/xl/worksheets/sheet1.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"/><Override PartName="/xl/calcChain.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.calcChain+xml"/><Override PartName="/xl/sharedStrings.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sharedStrings+xml"/><Override PartName="/docProps/core.xml" ContentType="application/vnd.openxmlformats-package.core-properties+xml"/></Types>

and then i start confusing with all syntax above. can anyone help me to simplify the problem.

**Johfra** · 05-09-2013, 03:11 PM

The creator of the file you're trying to open has a newer version of Excel. It is not compatible. The user/creator would need to save it differently (save it as Excel 2007).

"zzz.xlsx" is version 2010 (perhaps even 2013....I don't have that version but I would assume it would be the same).

**FDibbins** · 05-09-2013, 03:18 PM

@ Jophfra 2007 will open files from 2010 and 2013 just fine. there may be certain features that wont work, but that wont stop it from opening

**konami** · 05-09-2013, 11:53 PM

I ask to a person who made that file. she's said she made it from excel 2003. and I open her file in excel 2007. and I got unreadable error.

**FDibbins** · 05-10-2013, 01:58 AM

can you upload the file here? provided it does not contain sensitive data
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

**Johfra** · 05-23-2013, 10:37 AM

I had that problem here and I had to resave certain documents for our users using an older version. Perhaps there's more to it on our end if it should not have been a problem.

DaveDeV · 05-23-2013, 10:47 AM

I wonder if one Micro$oft's developers has a weird of humour and tests the filename and, if finds it contains a string = "zzz" causes Excel to fall asleep?