Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Font used in Word won't come up in Excel - usg as data base-envel | Excel Discussion (Misc queries) | |||
Automation of Font Resizing | Excel Discussion (Misc queries) | |||
Default font for Comments | Excel Worksheet Functions | |||
Why is first font action v-e-r-y slow? | Excel Discussion (Misc queries) | |||
How to change the default font and size of "comments"? | Excel Discussion (Misc queries) |