No More New Fonts May Be Applied In This Workbook
July 31st, 2008I 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.
January 28th, 2010 at 2:46 pm
Good solution you suggested.Thank you ,it saved me so much time.