Solved

Excel found unreadable content in 'filename'.xlsx

Posted on 2012-04-13
9
4,620 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
  • 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

828 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