Style from /xl/styles.xml part (styles) Undreadable Content

millencolinf2f

New Member
Joined
Oct 24, 2008
Messages
1
Hello,

Our CFO has been working on the budget for next year using Excel 2007. Today when he opened up workbook the following error appeared:

"Excel found unreadable content in 'documentname.xlsx'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."

After clicking Yes, then another error appeared saying:

"Excel was able to open teh file by repairing or removing the unreadable content.
Removed Records: Style from /xl/styles.xml part (Styles)"

I click Close and the workbook opens, but the formatting for all cells has been cleared. Is there anyway of retrieving this information? I have tried copying the styles.xml file from an older version of the file into the new one, but this only eliminated the error message and still left the file without formatting.

Thanks for any input on this matter.
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

sarlo00

Board Regular
Joined
Nov 13, 2002
Messages
105
Is there really no fix to this? Do I have to create my file again from scratch?
 

Howard Bonner

New Member
Joined
Jul 27, 2010
Messages
1
Hello,

Our CFO has been working on the budget for next year using Excel 2007. Today when he opened up workbook the following error appeared:

"Excel found unreadable content in 'documentname.xlsx'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."

After clicking Yes, then another error appeared saying:

"Excel was able to open teh file by repairing or removing the unreadable content.
Removed Records: Style from /xl/styles.xml part (Styles)"

I click Close and the workbook opens, but the formatting for all cells has been cleared. Is there anyway of retrieving this information? I have tried copying the styles.xml file from an older version of the file into the new one, but this only eliminated the error message and still left the file without formatting.

Thanks for any input on this matter.
Is there anyway I can permanently fix this problem?

Removed Records: Style from /xl/styles.xml part (Styles)
Repaired Records: Format from /xl/styles.xml part (Styles)
 

XLGeek

New Member
Joined
May 15, 2011
Messages
6
Posting reply since this thread was hanging unanswered, comes up at the top of most searches and the number of people getting this error is increasing.

The root cause of your problem is the same as "Too many different formats" error. Answer is here: http://answers.microsoft.com/en-us/...-formats/5b2fdc26-ed5b-4459-8461-5d9d89ebe9a9. You must run your file backup (if you have one) through style cleaner process or else you will end up in the same corrupted state really soon. I recommend Open XML based utilities because they will remove inaccesible to VBA hidden corrupted styles.
 

jae113

Board Regular
Joined
Jun 17, 2008
Messages
227
I'm also bumping this because I'm getting the same error, Repaired Records: Format from /xl/styles.xml part (Styles), when exporting from Access to Excel
 

The Art Of Brad

New Member
Joined
Jan 17, 2013
Messages
6
I know this is an old thread but the problems persists. I also came up against this issue and after searching online found that the issue was information that I copied and pasted from Ibm cognos Studio Analysis. I should have pasted it without formating. It seems that Excel isn't able to pick up the formating from Studio analysis. To resolve the issue I cleared the formating from the pasted information and the problem resolved.
How I got to this solution:
I copied the file to a test folder and fter very change I made in the file, saved it and opened it until the error disappeared - trial and error.
I followd the following steps and afte each step, save and open until he problem resolved
- delete all name - Formulas - Name Manager
- unhide all sheet - remove all !@#$%^&*() etc from sheet names and shorten sheet names
- delete sheet by sheet untill u find the error sheet
- in the error sheet delete rows and columns batch by batch until you find the error
 

Watch MrExcel Video

Forum statistics

Threads
1,089,760
Messages
5,410,268
Members
403,305
Latest member
tray2014

This Week's Hot Topics

Top