Adding a header forces new page

Excel 2007
Windows XP

I have some maintenance spreadsheets set up that we print out when we go out to a job. I needed a watermark in the background to give the image a look of being on company letterhead. To do that I inserted a picture as a header and it worked wonderfully - both when printing and when converting to PDF it looks like it's on company letterhead.

But for some odd reason inserting the picture as a header creates blank pages on each spreadsheet. This is a huge problem both when printing and when creating a PDF to send to customers. There are no cells carrying over to other sheets because when I remove the header it goes back to a single sheet. I've already tried:

1. Setting the print areas
2. Deleting hundreds of rows/columns after the ones I need
3. Resizing the image

I'm attaching a sheet that is an example of what's happening. As soon as you delete the header it goes back to fitting it all within the print areas I've specified.

What version of Excel are you using?

Regards

The reason I ask is that your profile says 2003 but the file has an .xlsx extension.

It views fine in Print Preview on Excel 2007 but gives a second, blank sheet (but for the watermark) in Excel 2003.

Regards

Looks fine as a .pdf file

That's what I see in 2003 although I didn't save it as a .pdf.

I don't think I can help you with this as the difference, for me, is between 2003 and 2007 ... not to do with the watermark itself.

Regards

For information ... I've asked for help:

http://www.excelforum.com/the-water-...-thread-5.html

Regards

Doesn't really explain why it works for me and not for you. Maybe a printer driver issue?

Regards