error message saying no more new fonts may be applied


U

uncleg

I am getting an error message in excel where I am using quite a few variety
of charts on various worksheets.

"no more fonts may be applied in this workbook"

I can not change any graphs as a result.

Can someone help please?

Thanks
 
Ad

Advertisements

D

Dave O

This is discussed at the Microsoft Knowledge Base, article 213904:

http://support.microsoft.com/default.aspx?scid=kb;en-us;213904

The error occurs when the workbook contains more than approximately
4,000 different combinations of cell formats. For example when you
format cell A1 as currency, then cell C1 as currency, Excel tracks
that as two ranges of formats. I used to encounter this error when I
was required to use a particular workbook at work: I got around the
problem by changing the format of some of the of "back office" tabs of
the workbook to a generic format. So if you have a lot of data tables
holding VLOOKUP information, for instance, but are not presented to
end users or for which appearance is not critical, you can do this:
1. Open the "too many formats" workbook, and simultaneously open a
blank workbook
2. In the blank workbook, select a cell and (from the menu) click
Edit >Copy
3. Flip to a non-critical tab of the affected workbook, right-click on
the "select all cells" in the upper left corner and in the menu that
appears, click >Paste Special >Formats. This converts all formatted
regions into unformatted space.

Dave O
Eschew Obfuscation
 
Ad

Advertisements

U

uncleg

Many thanks Dave for your help!

Dave O said:
This is discussed at the Microsoft Knowledge Base, article 213904:

http://support.microsoft.com/default.aspx?scid=kb;en-us;213904

The error occurs when the workbook contains more than approximately
4,000 different combinations of cell formats. For example when you
format cell A1 as currency, then cell C1 as currency, Excel tracks
that as two ranges of formats. I used to encounter this error when I
was required to use a particular workbook at work: I got around the
problem by changing the format of some of the of "back office" tabs of
the workbook to a generic format. So if you have a lot of data tables
holding VLOOKUP information, for instance, but are not presented to
end users or for which appearance is not critical, you can do this:
1. Open the "too many formats" workbook, and simultaneously open a
blank workbook
2. In the blank workbook, select a cell and (from the menu) click
3. Flip to a non-critical tab of the affected workbook, right-click on
the "select all cells" in the upper left corner and in the menu that
appears, click >Paste Special >Formats. This converts all formatted
regions into unformatted space.

Dave O
Eschew Obfuscation
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top