Massive problem: Excel has found unreadable content.

deadlyliquidx

New Member
Joined
Feb 6, 2015
Messages
27
Good Morning All!
I have having a major issue with excel.
Certain files keep saying Excel has found unreadable content, do you want to recover.
And then when it repairs it takes away all of my formatting!
This wouldn't be a problem if it didn't take a way my drop downs as well and I have a lot.
And it keeps happening...
I have exhausted all resources trying to find the core of the problem.
Here is what the message says after I repair.

Repaired Part: /xl/worksheets/sheet1.xml part with XML error. Load error. Line 2, column 0.
 

diddi

Well-known Member
Joined
May 20, 2004
Messages
2,554
that is almost certainly a read error off your hard drive. if you have another copy somewhere, go back and use it to cut your losses. sorry for the bad news. you might be able to undelete an old copy but excel is very good at writing over its awn files for some reason.
 

deadlyliquidx

New Member
Joined
Feb 6, 2015
Messages
27
No it happens in alot of other computers in the office.
Others have fixed this problem, I just need to know where to go to fix it.
 

Staftrax

New Member
Joined
May 2, 2015
Messages
5
I wonder if you can help, from reading an old post I think you had the same issue I'm having now but I can see if you resolved it.

When I open a workbook with a Macro I get this message " We found a problem with some content in 'Workbook_Name.xlsm'. Do you want us to try to recover as much as we can?"

Strangely, when I open the file on another User account on the same PC it works ok.

Any help would be appreciated
 

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,700
If you're on one of the Office 365 Insiders subscriptions, this was a problem with a recent Insiders builds. I suffered severely from this problem. You should check for an update, since my problem went away after an update last week.

In the meantime, select Cancel for recovering the file, then select a different cell or change the active sheet, and save again. Usually just changing sheets or even the active cell was enough to allow the save without getting that annoying message.
 

Staftrax

New Member
Joined
May 2, 2015
Messages
5
Thanks Jon, It's not an Insider sub and I seem to have the latest update,
Pro Plus 2016 Version 1801 (build 9001.2144)
my problem look to have started on 8th Feb.
I cant do as you suggest,
this started happening to all spreadsheet that with VBA macros. When you accept the option to recover it destroys the VBA and you are left with only the Worksheets. The same workbooks will work on another user account using the same PC.
 
Joined
Feb 8, 2002
Messages
878
Office Version
365
Platform
Windows
I will echo Jon on this point. The bug hit the insider builds for about 18 days before it was fixed. The first N times it happened, I simply Ctrl+Alt+Delete and lost my work.

But 9 time out of 10, the workbook *could* be saved. Choose another cell. Try to save again. Most of the time, it worked.
 

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,700
On my machine it affected any and all files. With or without VBA, with or without pivot tables and regular Tables, old files or new files being saved for the first time. Very frustrating, but usually the file could be saved if I changed the selection first.
 

diddi

Well-known Member
Joined
May 20, 2004
Messages
2,554
Try exporting your userforms and saving your modules and class modules into text files. then you can restore the "repaired" version. i had an excel crash event recently on a perfectly good userform which even stepped (F8) correctly, but refused to run. exported and deleted. saved, then imported and it has behaved ever since. no idea why
 

Staftrax

New Member
Joined
May 2, 2015
Messages
5
Not Ideal, but a solution that worked. Using the Fresh Start option in Defender, I reinstalled Windows while keeping all my Documents. All Workbooks with Macro's now work perfectly.
 
Last edited:

Forum statistics

Threads
1,078,356
Messages
5,339,729
Members
399,319
Latest member
sut3k

Some videos you may like

This Week's Hot Topics

Top