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.
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

diddi

Well-known Member
Joined
May 20, 2004
Messages
2,555
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,879
Office Version
365
Platform
Windows, MacOS
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
893
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,879
Office Version
365
Platform
Windows, MacOS
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,555
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:

Watch MrExcel Video

Forum statistics

Threads
1,102,872
Messages
5,489,432
Members
407,689
Latest member
Doublealpha

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top