No more new fonts may be applied to this workbook

[DOUG]

I have Excel 2003 (11.6113.5703) running on windows XP.
I have loaded the latest update from the web.

When I try to change the font size of text in the axis or
label of a chart, a message shows "No more new fonts may
be applied to this workbook."

When I do a print preview of the charts, the same message
shows up and then the print previews would be displayed.

I'd appreciate if you can tell me the fix.

 

[Debra Dalgleish]

Jon Peltier has some information on this in his Charting FAQ article:


http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#jon025

and at his web site (use this updated link instead of the one in his
article):

http://peltiertech.com/Excel/Charts/FixFonts.html

 

[Jon Peltier]

This is a well known problem in all modern versions of Excel:

http://support.microsoft.com/default.aspx?scid=kb;[LN];215573

There's a little bit about preventing it here:

http://peltiertech.com/Excel/Charts/FixFonts.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[DOUG]

I ran and stepped through your visual basic script, and
made sure that it selected each chart of my active
worksheet:

Sub FixAllChartFonts()
' Disable Font Autoscaling on All Charts on Active
Sheet
Dim myCht As ChartObject
For Each myCht In ActiveSheet.ChartObjects
myCht.Select
myCht.Chart.ChartArea.AutoScaleFont = False
Next
MsgBox ("done")
End Sub
After the script is done, I right-click on the chart
label and see that the AutoScale box is still checked.
Thus the script did not disable the Autoscaling. Do you
know if the script works for Excel 2003?

-----Original Message-----
This is a well known problem in all modern versions of Excel:

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

[LN];215573

There's a little bit about preventing it here:

http://peltiertech.com/Excel/Charts/FixFonts.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

I have Excel 2003 (11.6113.5703) running on windows XP.
I have loaded the latest update from the web.

When I try to change the font size of text in the axis or
label of a chart, a message shows "No more new fonts may
be applied to this workbook."

When I do a print preview of the charts, the same message
shows up and then the print previews would be displayed.

I'd appreciate if you can tell me the fix.

.

 

[DOUG]

It did disable autoscaling for the font in the chart
area. However, this did not solve the problem. It
appears each object has its own autoscaling checkbox, ie,
ChartTitle, Axistitle, etc... with autoscaling still
turned on.

-----Original Message-----
I ran and stepped through your visual basic script, and
made sure that it selected each chart of my active
worksheet:

Sub FixAllChartFonts()
' Disable Font Autoscaling on All Charts on Active
Sheet
Dim myCht As ChartObject
For Each myCht In ActiveSheet.ChartObjects
myCht.Select
myCht.Chart.ChartArea.AutoScaleFont = False
Next
MsgBox ("done")
End Sub
After the script is done, I right-click on the chart
label and see that the AutoScale box is still checked.
Thus the script did not disable the Autoscaling. Do you
know if the script works for Excel 2003?

-----Original Message-----
This is a well known problem in all modern versions of Excel:

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

[LN];215573

There's a little bit about preventing it here:

http://peltiertech.com/Excel/Charts/FixFonts.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

I have Excel 2003 (11.6113.5703) running on windows XP.
I have loaded the latest update from the web.

When I try to change the font size of text in the

axis

or

.

.

 

[Jon Peltier]

Doug -

In 2002 and in 97 (and I presume in 2000), setting the Autoscalefont to
false for the chart area set it to false for all of the chart's text
elements (axis and chart title, axis tick labels, legend, data labels).
I just checked to be sure. I don't have 2003 installed (yet), so I can't
see whether they went and changed the autoscale behavior.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

It did disable autoscaling for the font in the chart
area. However, this did not solve the problem. It
appears each object has its own autoscaling checkbox, ie,
ChartTitle, Axistitle, etc... with autoscaling still
turned on.

-----Original Message-----
I ran and stepped through your visual basic script, and
made sure that it selected each chart of my active
worksheet:

Sub FixAllChartFonts()
' Disable Font Autoscaling on All Charts on Active
Sheet
Dim myCht As ChartObject
For Each myCht In ActiveSheet.ChartObjects
myCht.Select
myCht.Chart.ChartArea.AutoScaleFont = False
Next
MsgBox ("done")
End Sub
After the script is done, I right-click on the chart
label and see that the AutoScale box is still checked.
Thus the script did not disable the Autoscaling. Do you
know if the script works for Excel 2003?

-----Original Message-----
This is a well known problem in all modern versions of
Excel:

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

[LN];215573

There's a little bit about preventing it here:

http://peltiertech.com/Excel/Charts/FixFonts.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

DOUG wrote:


I have Excel 2003 (11.6113.5703) running on windows
XP.

I have loaded the latest update from the web.

When I try to change the font size of text in the

axis

or

label of a chart, a message shows "No more new fonts
may

be applied to this workbook."

When I do a print preview of the charts, the same
message

shows up and then the print previews would be
displayed.

I'd appreciate if you can tell me the fix.

.

.