Excel error "no more fonts"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook with ~30 sheets. I copied a few sheets from another
workbook into it. My header and footer have now disappeared and when I want
to print preview or view the header, an error message pops up: "No more new
fonts allowed in this workbook". After pressing okay like 20 times or so it
goes away. How can I fix this?

THANKS!!!
Laurie
 
Lawoman35 said:
I have a workbook with ~30 sheets. I copied a few sheets from another
workbook into it. My header and footer have now disappeared and when I want
to print preview or view the header, an error message pops up: "No more new
fonts allowed in this workbook". After pressing okay like 20 times or so it
goes away. How can I fix this?
Click to expand...

I have not experienced this myself, but I can imagine that if the sheets are
formatted to fit to page when printed and you have a non-truetype font in your
header/footer, then an additional font would be needed.

Try reducing the number of fonts in use in your workbook and changing to a
truetype font.

Bill Manville
MVP - Microsoft Excel, Oxford, England
 
Back
Top