Everytime I try to change the source data of my charts in my spreadsheet, I get an error from the Office assistant saying that 'No more new fonts can be applied to this workbook'. But I'm not doing anything with fonts nor do I want to. It doesn't seem to be a problem when I change the source data, but it's starting to become a pain. Does anyone know why?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Font error message
- Thread starter cc5305
- Start date
Hi
There is a limit to the number of fonts that you can have in an Excel spreadsheet - I know this because I too have broken it. Once you have broken this limit any serious reformatting of your spreadsheet will generate the howling moan that you are getting as it attempts to redraw. Even reducing the number of fonts retains the error - but to get around this, remove the superfluous fonts and do a file>save as which cleared the "shadow" of the fonts from my files a treat.
[look - I know a lot of you will comment on the signature in this forum] Derren
[The only person in the world to like Word]
There is a limit to the number of fonts that you can have in an Excel spreadsheet - I know this because I too have broken it. Once you have broken this limit any serious reformatting of your spreadsheet will generate the howling moan that you are getting as it attempts to redraw. Even reducing the number of fonts retains the error - but to get around this, remove the superfluous fonts and do a file>save as which cleared the "shadow" of the fonts from my files a treat.
[look - I know a lot of you will comment on the signature in this forum] Derren
[The only person in the world to like Word]
- Status