In the response that I gave to Suresh, I was able to do this when I had
windows 2000. It only began to be a problem in XP so I was wondering if this
was an issue that Microsoft had a fix for or if I have a setting in excel
that needs to be changed.
Any other suggestions?

Thank you both for the responses.

"TomHinkle" wrote:

upon reading it further, I understand what you're trying to do... I don't
think you can do it witin headers & footers...

Microsoft expeimented with 'Microsoft Binder' in earlier versions of office
to do what you are trying (print sections of a document from different apps).
It never really caught on though and I don't know if there's an alternative.

(*** The least slick, but reliable way to do this is to insert page breaks
in your word doc that will print the appropriate footers, then feed these
sheets back into the printer to print your spreadsheets..)

"clubin" wrote:

When I try and use automatic page numbering (i.e. &[Page]+1) for my headers
and footers excel does not add properly, it simply places the number I use
after the "+" sign next to a 1,2,3 etc.

example - if I try and make a footer say page 5 by using &[Page]+4 it will
actually print "page 14", page 6 by using &[Page]+5 will actually print "page
15", etc.

Does anyone know if there is a fix for this? (I am using Excel 2002 in
Windows XP)

I appreciate any help, Thanks!