Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1124
  • Last Modified:

Excel 2007 Style Corruption

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
UALITGUYS
Asked:
UALITGUYS
1 Solution
 
mikeopoloCommented:
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
 
ScriptAddictCommented:
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now