User Profile
Dominiko93
Copper Contributor
Joined Jun 28, 2023
User Widgets
Recent Discussions
Re: Excel Error "No more new fonts may be applied. Please close some other documents and try again"
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.14KViews0likes0CommentsRe: Excel Error "No more new fonts may be applied. Please close some other documents and try again"
Hi, i have had this problem too. I made a quiet huge datebase in excel (4,5mb) , and then i experienced this problem multiple times on 1 document opened from time to time, less often however when i have had opened 2 documents at same time, then the "no new fonts" error make any work impossible to carry out. I dont know why the problem occurs but i think i might have found solution to it, at least cure. What I did with my document is that i simply opened second blank document (alternative) and then i have copied every spreadsheet i needed onto new worksheet by simply left clicking on each spreadsheet on the bottom tab, select "move or copy" and in the menu thick "copy", select to which document it has to be copied - in this case new blank sheet. and press ok. Then entire spreadsheet have been copied into new blank worksheet, you repeat it with every other spreadsheet. you need, then close old bugged document, and enjoy new copied document. I dont know what i just did, but it works for me. It seems like i kind of reset the memory, cache or something, because it dont bug me everytime now. However i do not guarantee if problem will not appear again if you will continue to add new fonts/formulas or formats. Because it definetelly has something to memory.14KViews0likes2Comments
Recent Blog Articles
No content to show