Forum Discussion
Methpong
Jul 22, 2022Copper Contributor
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 ) ...
FloJo21
Jun 29, 2023Copper Contributor
Hi Dominiko93
I really appreciate your responding to my comment.
Unfortunately I have already copied the sheets I could (& deleted/moved those I could do without) & recreated my file, but I guess I could try it again??
My file is ½ MB, so not as large as yours, but it does have multiple sheets.
I am finding if I have 2 files open at the same time I get this issue & have to Force Quit.
I am VERY frustrated about this issue as it is happening on a very regular basis & am not impressed that MicroSoft haven't fixed it yet. (At least I HOPE they're looking into it??)
Remind me again why I'm paying for a subscription???!! 😞
Dominiko93
Jun 29, 2023Copper Contributor
FloJo21 it's frustrating indeed. The error definatelly is related to multiple data, it might be because you have got multiple references to other cells, or I found there are issues also when you got formulas on merged cells, for e.g if you have 6 columns merged into one cell it seems like excel doesn't like it. What you can try, is to copy the sheets onto new document, but copy it the way I explained, not manually by copying and paste. Also you can try to limit the ammount of sheets of possible and divide it into let's say 2 documents. By this way you limit the data beeing processed at 1 time and so chance to bug your document with no fonts error.