hello, I've looked over the internet all morning, but cannot LOCATE any info on whether or not it's possible to only print one banner page when printing multiple copies of an excel sheet.  In MS Word, you can print one document of 30 pages and receive only 1 banner page, yet if you take an excel document or anything else which is contained as a single unit, you receive a banner page for however many copies you want to print.  Is there anyway to designate a number of copies to be printed under only one banner page?

anyone?The term "banner page" seems odd, when talking about Excel.  Exactly what do you mean?  Do you want to print a header on the first sheet or on all sheets?sorry.. no, I was SPEAKING of the banner page you can attach when dealing with the print driver.  And I should make it a bit more clear that this happens with mulitiple software programs.. it's not really an Excel issue.  I was just making an example.  The banner page is the blank page with your name on it that prints just PRIOR to every print job.  The problem is, when you print an excel sheet, or any other item which is contained within itself, you receive that banner page for every copy you choose to print.  The difference is in a document like MS Word, where all pages are contained within the original document, therefore only prints one banner page.  I guess the real problem is, that my boss is upset that he is wasting resources by printing 30 pages of an excel sheet and receiving 30 banner pages.

I hope that makes it a bit more clear.  - Anyone know how to print 30 copies of an excel sheet with only one banner page?

Thanks!What about canceling the banner page altogether?  Is that possibly an option?  Thanks... but if I do that... we'd have a hundred and fifty user's worth of documents all bunched together with no idea of who's is who's.  I told my boss it's just not an option.  So that's why I'm asking the world.  Interesting question.  I wish I knew the answer.  I can't even get my PERSONAL printer to print separator pages.  I see where I can to go printer Properties and select a separator page, but my printer simply has not recognized it so far.

Obviously, you're in an environment with a networked printer.  I think you may have some difficulty gettting an answer to this; I think it's an unusual and complicated problem.  You might try http://www.excelforum.com/.  What about the printer manufacturer, do they have a support forum on their site?  

A Google search, of course, turns up some info, such as SHARED printer separator page for Windows 2000 and Windows XP.  I see there are different types of separator pages.  Have you experimented any with that?Thank you for the more indepth suggestions, I will continue to look as well as try all of your suggestions.

Thanks... And if there is a way, I'll be sure to post the solution.