Error: "Too many different cell formats"

[extremme]

Hi guys, my company has a very comprehensive database which uses excel.
I am not sure if it is going to exceed the number of cells limited to
excel but I have been getting this error message: "Too many different
cell formats" whenever I tried to merge cell, insert new cell, create
borders etc.

Anyone encountered this before?? Pls advise.

 

[Guest]

Excel, for whatever reason, accumulates all cell formats, and they can only
be removed one by one!

ASAP-Utilities provides an utility to remove excessive formats. This tool
(with many more useful items, can be down loaded free from:
http://www.asap-utilities.com/

Good luck.

Felix

 

[extremme]

thks pal!

 

[extremme]

specifically wheredo I look under in ASAP utility to solve this?

 

[extremme]

any comments?

 

[Guest]

When you downloaded ASAP, you will find the Macro "Remove all unused styles