No More New Fonts May Be Applied In This Workbook

July 31st, 2008

I came across this very strange error message in Microsoft Excel today. The user has a workbook with 114 charts and he seemed to be hitting some hard limit in Excel.

It turns out that if you create a chart with it’s font set to ‘Auto scale’ then instead of using one font it uses 2 or more and there is a limit of 512 fonts per workbook. The fix is easy, there’s even a script to loop through all the chart objects and change the setting for you.

For the solution see the page on the Microsoft Help and Support.

One response

  1. pc.de free fonts comments:

    Good solution you suggested.Thank you ,it saved me so much time.

Leave a comment