Solved

Excel found unreadable content in 'filename'.xlsx

Posted on 2012-04-13
9
4,465 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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

747 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

13 Experts available now in Live!

Get 1:1 Help Now