Excel 2007 Header Doesn't Print
 

I have a number of workbooks created in Excel 2003 which displayed and
printed the headers and footers properly. When I open some of them in Excel
2007, to which we just upgraded, they don't display or print. Yet, when I
set the view to page layout, the header/footer appears as I scroll across
them, and I see them in Page Setup. Other workbooks display and print fine.
What might be my problem?

Excel 2007 Header Doesn't Print
 

Discovered the cause and solution. A second clue arose where, as I attempted
to type in the header, nothing would appear on screen or paper, i.e., act
like invisible ink. For whatever reason, the font color was non-existent
even though the color box said automatic. Solution is to bring up the header
in Page Setup, edit the custom header/footer, click on the font button, click
on the font color box, select automatic or color wanted, click the ok button
in the font window and the header/footer window. note, to simply click on
the font button then OK was not enough.

"climber" wrote:

I have a number of workbooks created in Excel 2003 which displayed and
printed the headers and footers properly. When I open some of them in Excel
2007, to which we just upgraded, they don't display or print. Yet, when I
set the view to page layout, the header/footer appears as I scroll across
them, and I see them in Page Setup. Other workbooks display and print fine.
What might be my problem?