Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
No New Font
 
Posts: n/a
Default What is the meaning of "No new font may be applied in this workbo.

When updating each of chart data series in a workbook, the message "No new
font may be applied in this workbook" appears prior to changing data series.
What did I do to prompt this message, how do I correct?
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

Your charts are probably set to use font autoscaling, which uses twice
the font resources as not autoscaling. In the font dialog, there's a
checkbox for Auto scale, which should be unchecked.

This is a pain to fix if you have enough charts to cause the warning,
but I have some VBA procedures on the following page to fix an existing
condition, and a registry hack to prevent it in the future. (Not prevent
it, really, but put off its occurrance for twice as long).

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

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


No New Font wrote:
When updating each of chart data series in a workbook, the message "No new
font may be applied in this workbook" appears prior to changing data series.
What did I do to prompt this message, how do I correct?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Font used in Word won't come up in Excel - usg as data base-envel SLJackson Excel Discussion (Misc queries) 1 September 10th 05 12:31 AM
Automation of Font Resizing Mike Excel Discussion (Misc queries) 0 August 29th 05 09:50 PM
Default font for Comments Debra Dalgleish Excel Worksheet Functions 0 August 25th 05 11:55 PM
Why is first font action v-e-r-y slow? [email protected] Excel Discussion (Misc queries) 2 March 11th 05 08:01 AM
How to change the default font and size of "comments"? ClayMcQ Excel Discussion (Misc queries) 1 January 7th 05 11:43 PM


All times are GMT +1. The time now is 09:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"