Excel

[Adam]

I'm getting an alret in Excel that reads as follows.

"No More New Fonts may be Applied in this Workbook." I cannot change graph
data or excel errors out. I current have 21 worksheets in this workbook, of
which 19 are sheets that have 8 grapgs per worksheet. The total size of the
workbook is approx. 910kb.

[MWE]

Excel seems to have some upper limit re the number of graphs or charts that can be embedded in a given workbook. It probably depends on the complexity of each graph and several factors. I have run into this problem several times and no one has ever provided a good explanation of what was really happening and how to fix it. Most responses indicated that the underlying problem was Excel's inability to properly release resources no longer needed.

I hope someone with more knowledge re Excel than I have sees this thread and provides a useful explanation and workaround.

[Jason Morin]

See this MS KB article for potential remedies:

http://support.microsoft.com/default.aspx?scid=215573

HTH
Jason
Atlanta, GA

>-----Original Message-----
>I'm getting an alret in Excel that reads as follows.
>
>"No More New Fonts may be Applied in this Workbook." I
cannot change graph
>data or excel errors out. I current have 21 worksheets
in this workbook, of
>which 19 are sheets that have 8 grapgs per worksheet.
The total size of the
>workbook is approx. 910kb.
>.
>

[vonpookie]

I am unable to turn off autoscaling either manually or by using the macro
provided in the kb article. When I select a chart and try to turn off
autoscaling manually, it gives me the "no more new fonts" error again, and
the autoscaling is not turned off.

If I use the macro, it says x number of charts where changed, but viewing
the format tab of many charts still shows it is set to true--and I still am
unable to manually turn it off.

Another weird bug perhaps?
(Excel 2002/Win2000)

"Jason Morin" wrote:

> See this MS KB article for potential remedies:
>
> http://support.microsoft.com/default.aspx?scid=215573
>
> HTH
> Jason
> Atlanta, GA
>
> >-----Original Message-----
> >I'm getting an alret in Excel that reads as follows.
> >
> >"No More New Fonts may be Applied in this Workbook." I
> cannot change graph
> >data or excel errors out. I current have 21 worksheets
> in this workbook, of
> >which 19 are sheets that have 8 grapgs per worksheet.
> The total size of the
> >workbook is approx. 910kb.
> >.
> >
>