Repeat alert, "No more new fonts may be applied to this workbook"

G

Guest

I several of my larger workbooks, I get a repeat alert "No more new fonts may
be applied to this workbook" when I save, make changes or print the workbook
or selected worksheets. This happens on both my office computer running
Excel 2003 and home computer running Excel 2000. To complete the desired
action, I must click <OK> for as many as five times per worksheet. It must
be caused by a setting in the workbook. Does anyone know what causes this
and how to correct it?
 
G

Guest

Thanks for the quick reply Debra - now for the next part. I think I may be
beyond the point of no return. When I select chart elements deselect
auto-scaling, I get the same alert and the change does not take effect. i.e.
when I select the same element that I just unclicked auto-scaling on, the box
is still checked.

The current workbook is only 37 worksheets with 4 charts each. I often
extend beyond 100 worksheets with 2 to 4 charts. Each sheet is an individual
analysis of a project element done in copies of a master worksheet. Now I
know to change the worksheet design to avoid this problem in the future, but
can I recover my current project, or am I doomed to waste my time hitting
<OK> to get through this?
 
G

Guest

As I just found it, in order for this to work, you can not be in a status of
having too many fonts. I had to delete a page of charts, fix the remainder of
the workbook, and now I must recreate the page over again.

This sucks. I hope Microsoft creates a fix for this in the next version of
Excel.
 

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