Error - No more new fonts in this workbook
 

I have a fairly large workbook. I want to simply copy one spreadsheet to
another tab. I get an error message that says "No more new fonts may be
applied to this workbook". Then the error message sign itself cannot be "X"'d
out. I have to control/alt/delete. What should I do? Please help!
James A

Error - No more new fonts in this workbook
 

You've probably hit a limit as to the number of fonts that can be displayed
in a single workbook.

Best to keep workbooks to a few fonts.

Dave
--
Brevity is the soul of wit.


"James A" wrote:

I have a fairly large workbook. I want to simply copy one spreadsheet to
another tab. I get an error message that says "No more new fonts may be
applied to this workbook". Then the error message sign itself cannot be "X"'d
out. I have to control/alt/delete. What should I do? Please help!
James A

Error - No more new fonts in this workbook
 

Actually I just changed the entire workbook to one font - but I still get the
error message? What else can I do?
--
James A


"Dave F" wrote:

You've probably hit a limit as to the number of fonts that can be displayed
in a single workbook.

Best to keep workbooks to a few fonts.

Dave
--
Brevity is the soul of wit.


"James A" wrote:

I have a fairly large workbook. I want to simply copy one spreadsheet to
another tab. I get an error message that says "No more new fonts may be
applied to this workbook". Then the error message sign itself cannot be "X"'d
out. I have to control/alt/delete. What should I do? Please help!
James A

Error - No more new fonts in this workbook
 

As a first step, I would save the file under a different name, close XL
completely, re-open the new file, and see if you still get the error.

Dave
--
Brevity is the soul of wit.


"James A" wrote:

Actually I just changed the entire workbook to one font - but I still get the
error message? What else can I do?
--
James A


"Dave F" wrote:

You've probably hit a limit as to the number of fonts that can be displayed
in a single workbook.

Best to keep workbooks to a few fonts.

Dave
--
Brevity is the soul of wit.


"James A" wrote:

I have a fairly large workbook. I want to simply copy one spreadsheet to
another tab. I get an error message that says "No more new fonts may be
applied to this workbook". Then the error message sign itself cannot be "X"'d
out. I have to control/alt/delete. What should I do? Please help!
James A

Error - No more new fonts in this workbook
 

James

Have a peek at this KB Article on the subject.

http://support.microsoft.com/kb/215573/en-us


Gord Dibben MS Excel MVP

On Mon, 11 Dec 2006 13:28:00 -0800, James A
wrote:

Actually I just changed the entire workbook to one font - but I still get the
error message? What else can I do?

Error - No more new fonts in this workbook
 

Thanks, This is exactly what I needed.
--
James A


"Gord Dibben" wrote:

James

Have a peek at this KB Article on the subject.

http://support.microsoft.com/kb/215573/en-us


Gord Dibben MS Excel MVP

On Mon, 11 Dec 2006 13:28:00 -0800, James A
wrote:

Actually I just changed the entire workbook to one font - but I still get the
error message? What else can I do?