Solved

Excel found unreadable content in 'filename'.xlsx

Posted on 2012-04-13
9
4,528 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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now