Excel found unreadable content in 'filename'.xlsx

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
LVL 1
adamformanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

redmondbCommented:
Hi, adamforman.

Any chance that you could post the file here?

Thanks,
Brian.
0
adamformanAuthor Commented:
Hey Brian.

Thanks for replying, here is the file in question.

Week-11-WSA-Annies-Barnes-15-04-.xlsx
0
redmondbCommented:
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
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

redmondbCommented:
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
adamformanAuthor Commented:
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
redmondbCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
redmondbCommented:
Thanks, LeeTutor.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.