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

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

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
 

Forum statistics

Threads
1,089,489
Messages
5,408,565
Members
403,215
Latest member
DblDocWhitaker

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top