Excel error "no more fonts"

[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

 

[Bill Manville]

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?

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