How many fonts can be used in an Excel worksheet?

[Robert]

I have a user that received an error message that states
that 'No more new fonts may be applied to the workbook'...

This implies a limit to the number... How many can be used?

Thanks...

 

[Charles Williams]

According to Msoft its about 4000, but there is no non-manual way of
counting. A font is a combination of the font name, size, and properties.
Most people seem to think its actually less than 4000, but i doubt anyone
has actually counted.


regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

 

[Robert]

So this user has a problem with Excel them. It is a
document with 35 worksheets and 17 of the sheets have
three graphs on them.

Could this be a memory issue? It seems kinda odd that it
would be erroring out with this message... I'd expect a
memory issue to have a different message...

Hopeing for coherent error messages is getting better...

 

[Charles Williams]

Hi Robert,

Apologies: i gave you information about the maximum number of formats, not
fonts.

In Excel 97 this used to be 256, not sure if this has changed in later
versions.
MSoft recommends turning off autoscaling since this doubles the number of
fonts used.
Fonts count includes both style and size.

see
http://support.microsoft.com/default.aspx?scid=kb;en-us;215573&Product=xlw

Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

 

[MPW]

I am using MS365 for enterprise
Wrote a macro to display all available installed fonts (About 1,200)
Macro choked at a little over 1,000. Excel was the limiting factor.