General discussion

Locked

Excel Bug: Too many cell format

By volak_sao ·
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.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel Bug: Too many cell format

by DKlippert In reply to Excel Bug: Too many cell ...

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)

Collapse -

Excel Bug: Too many cell format

by DKlippert In reply to Excel Bug: Too many cell ...

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

Collapse -

Excel Bug: Too many cell format

by volak_sao In reply to Excel Bug: Too many cell ...

Poster rated this answer

Back to Windows Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums