No More New Fonts may be Applied in this Workbook

In Microsoft Excel, sometimes when you add a new or existing chart to a workbook in you may receive the error message below:
No More New Fonts may be Applied in this Workbook

This problem is caused by Excel’s Auto scale setting. When adding a chart to a workbook, Excel automatically enables the Auto scale. The Auto scale forces the chart to use two or possibly more fonts instead of one font.  As a result, you can very quickly exceed the maximum number of fonts (512) allowed in Excel when adding multiple charts.  If you add charts manually or if you copy and paste existing charts, you can reach the font limitation for a workbook.

To prevent this problem from occuring you could disable the Autoscale setting.

  1. Select the chart.
  2. In the Format menu, select Selected Chart Area.
  3. Select the Font tab.
  4. Unselect the Autoscale check box.
  5. Click OK.
  6. Repeat the above for multiple charts that you may have.

513 thoughts on “No More New Fonts may be Applied in this Workbook

  1. ig

    Hey, I think your blog might be having browser compatibility
    issues. When I look at your website in Firefox, it looks fine but
    when opening in Internet Explorer, it has some overlapping.
    I just wanted to give you a quick heads up! Other then that, very good
    blog!

  2. köp skäggset

    This post was amazing i actually read your blog fairly
    often, and you’re always coming out with pretty
    great stuff. I embedded this on my blog, and my followers
    loved it. Keep up the very good work 🙂

  3. smellgood.se/

    Wow, awesome blog layout! How lengthy have you ever been blogging for?
    you make blogging glance easy. The whole glance of your web site is great, as neatly as
    the content material!

  4. skäggolja

    Hey! Someone in my Facebook group shared this website with us so I came to
    take a look. I’m definitely enjoying the information.
    I’m book-marking and will be tweeting this to my followers!
    Excellent blog and outstanding design.

  5. Skäggprodukter

    Heya i’m for the primary time here. I found this board and I to find It truly helpful & it helped
    me out much. I am hoping to present one thing back and help others like you helped me.

Comments are closed.