Excel 2007 Constantly Creating Custom Cell Styles

Question

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.

Answer 1

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.