Discussion Locked

Excel Bug: Too many cell format

0 helpful

3 replies

by volak_sao Jul 1, 2001 last reply Jul 4, 2001 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I use huge files in MS Excel 97/NT Environment with complicated links between sheets. Once it gets bigger and more complicated, there comes a message "Too many cell format" and I can't make changes to the cell format of whole file. Approx. sheets is80. A friend told to delete all custom formats and I did so but it didn't help anyway. Appreciate your help.

3 replies

by dklippert Jul 1, 2001

MS says its because you have about 4000 combinations of formating. Here is the article that offers some suggested remedies.Such as, one font throughout.
http://support.microsoft.com/support/kb/articles/Q213/9/04.asp (there are no spaces in the URL)

by dklippert Jul 1, 2001

BTW have you tried selecting multiple sheets and then applying formatting change to all the shhets in the selectin?

by volak_sao Jul 4, 2001

Poster rated this answer

This discussion is closed to new replies.

3 replies

Trending Windows Forum posts

How are you using AI agents in your daily workflow

Do You Save Useful Windows Tutorial Videos for Later

What is the most annoying Windows problem you have faced and what finally fixed it

Is WSL still relevant in 2026?

Developing or Testing Puzzle Games on Windows 11