Forum Discussion
Excel Error "No more new fonts may be applied. Please close some other documents and try again"
Bother question Excel H&B 2019 : Alert " No more new fonts may be applied" every time edit cell. File size is not that big ( 7xx KB ) but have 16 sheet ( in sheet have many formula and link ) ...
Got the message popping for weeks and getting in the way of my productivity.
Try this:
File / Info / Check for Issues / Inspect Document
and fix the issues found.
Seems to be working for me.
Hope it helps.
Try this:
File / Info / Check for Issues / Inspect Document
and fix the issues found.
Seems to be working for me.
Hope it helps.
ruibm suggestion to fix problems within the doc also worked for me - The spreadsheet had a few circular references and formulas that were bonked, File > Info > Check for Issues > Inspect Document located the issues and we repaired each. The ambiguous font error also disappeared when the formulas were corrected and updated. If you close the file in question and open it back up, it should present you with a message indicating the underlying problem with the document. Fix the errors, save the file and close it. Once the error message disappears upon reopening the file, you should be able to continue working on the file without seeing the font error again.
Hi
Thanks for responding & your suggestion.I am still getting the message & if I have 3 Excel documents open at any one time I have to Force Quit Excel (I know it sounds a lot, but it was never a problem in the past to have multiple docs open..)
My issue is that I do get the message that I have circular references, but when I check each of the formulas they are correct!! They are just sums of cells.
I have tried "ignore" so will see what happens next!!!
