Solved

Excel found unreadable content in 'filename'.xlsx

Posted on 2012-04-13
9
4,687 Views
Last Modified: 2012-08-13
I have an Excel document, consisting of 16 sheets, of which most point to others with values, with mostly small formulas. I have been using this document on a day to day basis, and has worked perfectly, before it suddenly started to come up with the message

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

After clicking yes to try and repair the document, I am met with the following report;


<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error035600_01.xml</logFileName>
<summary>Errors were detected in file 'C:\Users\jordan\Downloads\filename.xlsx'</summary>
-<additionalInfo><info>Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.</info>
</additionalInfo>
-<removedParts summary="Following is a list of removed parts:">
<removedPart>Removed Part: Print options.</removedPart>
<removedPart>Removed Part: Print options.</removedPart>
<removedPart>Removed Part: Print options.</removedPart>
<removedPart>Removed Part: Drawing shape.</removedPart>
<removedPart>Removed Part: Print options.</removedPart>
<removedPart>Removed Part: Drawing shape.</removedPart>
<removedPart>Removed Part: Print options.</removedPart>
<removedPart>Removed Part: Print options.</removedPart>
<removedPart>Replaced Part: /xl/worksheets/sheet17.xml part with XML error. Quote expected. Line 2, column 49066.</removedPart>

Open in new window

error035600-01.xml

And its log counterpart.

Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.
Removed Part: Print options.
Removed Part: Print options.
Removed Part: Print options.
Removed Part: Drawing shape.
Removed Part: Print options.
Removed Part: Drawing shape.
Removed Part: Print options.
Removed Part: Print options.
Replaced Part: /xl/worksheets/sheet17.xml part with XML error.  Quote expected. Line 2, column 49066.
Removed Records: Worksheet properties from /xl/workbook.xml part (Workbook)

Open in new window

error035600-01.xml

Here is a list of what I have tried to do so far;

I have tried renaming the document, saving/changing to different file types, opening the different file types and saving back into its original file format, using Excel 2007 and 2010, moving between Windows 7 and XP and using the various 'open' options when in Excel.
filename.txt
0
Comment
Question by:adamforman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
9 Comments
 
LVL 26

Expert Comment

by:redmondb
ID: 37844454
Hi, adamforman.

Any chance that you could post the file here?

Thanks,
Brian.
0
 
LVL 1

Author Comment

by:adamforman
ID: 37850463
Hey Brian.

Thanks for replying, here is the file in question.

Week-11-WSA-Annies-Barnes-15-04-.xlsx
0
 
LVL 26

Expert Comment

by:redmondb
ID: 37850647
adamforman,

Thanks. I opened the file and got the same repair details as yourself. Once I save the file, the errors go away (please see attached). Is that what you were looking for or did you want some explanation as to what happened to the file in the first place?

Regards,
Brian.
Week-11-WSA-Annies-Barnes-15-04-.xlsx
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 26

Expert Comment

by:redmondb
ID: 37850749
adamforman,

To continue...

I tried to unzip the contents of your original file, but the zip is corrupt. I ran a Zip repair program and this recovered some of the file. Comparing this recovered file with the repaired file from Excel (included in my previous post), it's clear that neither file includes all of the original data.

My recommendation would be to restore a clean backup or rebuild the file from scratch (i.e. it would be OK to copy cells, but not sheets.)

Regards,
Brian.
0
 
LVL 1

Author Comment

by:adamforman
ID: 37850769
Hey Brian,

Thanks for taking your time to look into this, I will probably try and do just that but I'm still going to be looking around to see if there is a way around it, because this will take a long time to remake.

Would you be able to inform me as to what could have caused something like this to happen to this document?


Regards,
Adam.
0
 
LVL 26

Accepted Solution

by:
redmondb earned 500 total points
ID: 37851058
adamforman,

Neither Windows nor Excel is perfect. For example, Excel's sharing mechanism is notoriously weak and prone to corrupting files, but even "ordinary" spreadsheets will go bad for no obvious reason.

Think very carefully about attempting to recover the file - four separate programs (Excel, Explorer, 7-Zip and ZipRepair) have each found the file corrupt. No matter what you do to this file, there will always be the concern that there is an underlying fault which will reoccur - usually at the most unfortunate time.

Regards,
Brian.
0
 
LVL 26

Expert Comment

by:redmondb
ID: 37974647
Thanks, LeeTutor.
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
The Windows functions GetTickCount and timeGetTime retrieve the number of milliseconds since the system was started. However, the value is stored in a DWORD, which means that it wraps around to zero every 49.7 days. This article shows how to solve t…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question