Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Excel 2007 Style Corruption

Posted on 2012-04-11
2
1,048 Views
Last Modified: 2012-08-13
Our Accounting department constantly calls the help desk complaining that their Excel Spreadsheets have lost all of their format.

When we open the Excel file, it shows a message that says the styles were corrupt and have been removed:

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

This seems to happen quite a bit and is extremely annoying...

Any ideas?
Brian
0
Comment
Question by:UALITGUYS
2 Comments
 
LVL 10

Expert Comment

by:mikeopolo
ID: 37836050
Not sure if this will work, but worth checking out:

If you open the list of custom formats, you may see one that looks like:
"[$-409]d-mmm-yyyy h:mm AM/PM;@"

If you delete it then all the affected cells should revert to general format.

I've seen this reported on other forums without yet seeing a reason or 'proper' fix.

Regards
Mike
0
 
LVL 11

Accepted Solution

by:
ScriptAddict earned 500 total points
ID: 37838907
This article details the problem, and the solution.  Best of luck

http://sergeig888.wordpress.com/2011/05/06/msft-released-hot-fix-for-excel-2007-custom-styles-duplication/ 

-SA
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question