Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've been using Office 2007 for a few months now and have noticed that it was creating duplicate custom cell styles on its own, like Normal 2, Normal 3, etc. It didn't really bother me at first, but now Excel will lag when I open the cell styles menu as it gathers well over a hundred of these duplicates (I have seen Normal 54 and Normal 5 2 2 so I'm unsure as to how many there actually are). I have also just checked a fresh Excel sheet, and it only has the defaults, but one I created earlier today from scratch has the Normal 54 listed. My questions are:

Why is this happening? Can I delete a temp or custom settings file somewhere to clear this?

Any help on this is appreciated.

share|improve this question
This is a strange behaviour. Get your PC scanned for viruses. – serena Dec 21 '09 at 23:33
I have the latest Symantec Antivirus definitions and it detects nothing. – Nick Dec 22 '09 at 4:33

Try running the Microsoft Office Diagnostics tool on your PC. (Used to be called "Detect and Repair")

To do this, click the Microsoft orb in Excel (the main menu) and click "Excel Options" at the bottom of the menu.

Click on "Resources" on the left, and then the "Diagnose" button on the right.

The Microsoft Office Diagnostics window will open - run the diagnostics and see if any repairs it makes help.

The Diagnostics tool can also be accessed through your Start menu, by finding the Microsoft Office 2007 folder, then Microsoft Office 2007 Tools, and finally Microsoft Office Diagnostics.


share|improve this answer
Didn't seem to find anything, although the problem seems to have gotten better over time and I've made no changes, other than perhaps just regular Microsoft updates. – Nick Jan 20 '10 at 15:48

You must log in to answer this question.