Solved

Excel Error Message - Too Many Fonts

Posted on 2009-04-04
5
1,148 Views
Last Modified: 2013-12-29
I apparently have a bloated workbook.  Painfully slow inserting rows/columns.
Frequent error message "too any fonts on this sheet..."
After several dozen clicks it disappears.
I tried selecting the entire sheet and a one font.  That does not seem to help.

I have changed the default font in the tools/options menu from arial to calibri, which i would now like to use in all workbooks.  Even with the default changed, arial shows up when creating new worksheets or starting new workbooks most of time.

Three Questions-

1. How do i get rid of the error message?

2. How to I teach excel to use the default font specified in the tools/options screen?

3. Would it help if I cleaned out the huge selection of fonts in windows?

Thanks,
Bill
0
Comment
Question by:BW999
  • 3
5 Comments
 
LVL 15

Accepted Solution

by:
greyknight17 earned 250 total points
ID: 24067882
How many fonts do you have installed there? If you installed a bunch, you might consider removing them if they are not all needed.

If you want Excel to default to a specific font, you can save it as a template file so Excel reuses it every time. For more information read here. You will just change the font to the one you want and then save it as a template.
0
 
LVL 16

Assisted Solution

by:warturtle
warturtle earned 250 total points
ID: 24071150
Need some more information to be able to help:

1. Do you have any macros running in the background?
2. Do you have lots of charts in the document?
3. Are you able to split the documents into multiple workbooks?
0
 
LVL 15

Expert Comment

by:greyknight17
ID: 24092973
Bill, is there any update on this problem?
0
 

Author Comment

by:BW999
ID: 24098275
I set up the template files.  They work fine for new workbooks.  

My windows/font folder had 498 files!   I started moving some of them out of the font folder, but stopped because I wanst sure wheter any of them were tied to specific applications that I didnt want to mess up.  Is there a utility of some sort that identifies useless vs. critical font files?

I am still having problems with the font error message in one bloated workbook.   I removed the conditional formatting that was in some sheets.  I was going to reset all of the sheets to use the "default" font.   I Unlike font colors, cell colors, etc , however, the option to select the default font does not appear in the menus.    I can manually select the font specified in the template file.
0
 
LVL 15

Expert Comment

by:greyknight17
ID: 24112553
I don't know of an easy way to do this, but here is what I have in my system:

ANTQUAB.TTF    ANTQUABI.TTF   ANTQUAI.TTF    arial.ttf      arialbd.ttf
arialbi.ttf    ariali.ttf     ARIALN.TTF     ARIALNB.TTF    ARIALNBI.TTF
ARIALNI.TTF    ariblk.ttf     BKANT.TTF      BOOKOS.TTF     BOOKOSB.TTF
BOOKOSBI.TTF   BOOKOSI.TTF    BSSYM7.TTF     comic.ttf      comicbd.ttf
cour.ttf       courbd.ttf     courbi.ttf     couri.ttf      estre.ttf
framd.ttf      framdit.ttf    GARA.TTF       GARABD.TTF     GARAIT.TTF
gautami.ttf    georgia.ttf    georgiab.ttf   georgiai.ttf   georgiaz.ttf
GOTHIC.TTF     GOTHICB.TTF    GOTHICBI.TTF   GOTHICI.TTF    HATTEN.TTF
impact.ttf     kartika.ttf    latha.ttf      lsans.ttf      lsansd.ttf
lsansdi.ttf    lsansi.ttf     lucon.ttf      l_10646.ttf    mangal.ttf
micross.ttf    modern.fon     mvboli.ttf     OUTLOOK.TTF    pala.ttf
palab.ttf      palabi.ttf     palai.ttf      raavi.ttf      REFSAN.TTF
REFSPCL.TTF    roman.fon      script.fon     shruti.ttf     sylfaen.ttf
symbol.ttf     tahoma.ttf     tahomabd.ttf   times.ttf      timesbd.ttf
timesbi.ttf    timesi.ttf     trebuc.ttf     trebucbd.ttf   trebucbi.ttf
trebucit.ttf   tunga.ttf      verdana.ttf    verdanab.ttf   verdanai.ttf
verdanaz.ttf   vrinda.ttf     webdings.ttf   wingding.ttf   WINGDNG2.TTF
WINGDNG3.TTF   wst_czec.fon   wst_engl.fon   wst_fren.fon   wst_germ.fon
wst_ital.fon   wst_span.fon   wst_swed.fon  
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
In this article, I will show you HOW TO: Perform a Physical to Virtual (P2V) Conversion the easy way from a computer backup (image).
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now