"No more new fonts may be applied to this workbook"

[Guest]

I have an annoying problem that apparently has to do with the number of
charts in my workbook.
I am using Excel 2002 SP-1.

I have a workbook that consists of 7 worksheets and is only 589 KB but I
have a large number of charts. As I developed this workbook and the number
of charts started to increase I started to get the error message, "No more
new fonts may be applied to this workbook" even though I was not adding any
new fonts. This usually happened when I tried to change the chart title. I
would just click through several of these messages and everything would be
OK. Now I cannot even click on a pull-down without getting this error
message. I can enter data and that's about all. I don't want to break up
this workbook because it needs to be distributed. What is causing this and
what can I do about it?

Thanks for your advice.

Steve H

 

[Jon Peltier]

Steve -

When you have multiple charts each on several worksheets within a
workbook, you may burn through the system resources Excel uses for
charts. Apparently Excel needs dedicated font resources for each chart
(even if the charts use the same fonts), and if font autoscaling is
enabled, the resource requirements are doubled. Font autoscaling can be
disabled for each chart to alleviate this resource crisis. Here's
Microsoft's take:

XL2000: Error Copying Worksheets Containing Charts
http://support.microsoft.com/?id=215573

- Jon

 

[Jason Morin]

This Microsoft KB article may help:

XL2000: Error Copying Worksheets Containing Charts
http://support.microsoft.com/default.aspx?scid=kb;en-us;215
573

HTH
Jason
Atlanta, GA

 

[Guest]

That was certainly enough! Thanks to all for your help.

Steve