Forum Discussion

J_Loo's avatar
J_Loo
Copper Contributor
Jul 28, 2022

Excel bugs-hang up : "No more new fonts, close other docs and try again"

Hi: I am using office 2019.  After opening my 51MB excel file (even in "Safe Mode"), excel prompts an message:  "No more new fonts, close other docs and try again".   I notice in the formula bar, ...
excel
Martin_Weiss's avatar
Martin_Weiss
Bronze Contributor
Aug 01, 2022

Hi J_Loo 

 

there is a limit of 512 unique font types that can be used within a workbook. Here is an overview of all Excel limitations:

https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3

 

Maybe you have too many different fonts installed on your computer?

J_Loo's avatar
J_Loo
Copper Contributor
Aug 02, 2022

Hi, Martin_Weiss
Thank you for your reply.


If this is the case, could you please let me know how could I reduce the numbers of fonts to avoid the hanging up of my file.

Now the file will hang up even when I try to delete a worksheet from the file to see if I can reduce the hangup problem.

 

Thanks

 

  • Martin_Weiss's avatar
    Martin_Weiss
    Bronze Contributor
    Aug 02, 2022

    Hi J_Loo 

     

    first you should check if the number of fonts is really so high. You have to do this outside of Excel in the Windows control panel. There you could see how many fonts you have installed:

     

    If you have a real high number, you can think about removing some of them. But be careful, you do this at your own risk!

    • J_Loo's avatar
      J_Loo
      Copper Contributor
      Aug 06, 2022

      hi, Martin_Weiss 

       

      Thank you for your suggestion. 

       

      Total numbers of fonts installed in my PC was 119 items, and according to your suggestion, according to your suggestion, I have deleted most of them (many fonts are protected by the system and cannot be deleted), the final numbers of font left is 92 items.

       

      After the deletion, and when I restarted my excel, the issue wasn't solved.  Same error messages boxes such as "No more new fonts, close other doc ...", "No more memory to display..." 

       

      The worst is that the formula in the formula bar has changed to bold fonts automatically and beyond control over font size change, please see attached files. 

      It looks the number of fonts installed is not much relevant with the issue, instead it may be the bugs in Office 2019 (when in use with Excel) crashed within the OS system of Window 10 !!!

       

      Thank you.

       

      P.S. - Before the deletion of fonts, I have also deleted all "Conditional format settings", checked all circular formulae and traced and clear all formula errors in the file. But this still dosen't help !!!

       

       

       

      • Martin_Weiss's avatar
        Martin_Weiss
        Bronze Contributor
        Aug 08, 2022

        Hi J_Loo 

         

        I'm sorry to hear that the issue was not solved (119 fonts are not a large number, anyway).

        It seems that you have deleted some system relevant fonts, thats probably the reason why you get strange fonts in the formular bar.

        I found an an article on how to restore fonts:

        https://answers.microsoft.com/en-us/windows/forum/all/how-to-restore-default-fonts-in-windows-10/587caab0-50a0-4650-a69b-aeb1e7219815

         

        Do you get the same error message when you use the file on a different computer?

         

Resources