Printing Multiple Copies??

[Alex Clark]

Hi All,

(Running Office 2003 on XP Pro workstations, SBS 2003 server).

I've noticed that if you tell Excel to print multiple copies of a workbook,
it sends the same document to the printer multiple times - i.e., for 3
copies of "MyWorkbook1.xls", I get 3 entries in the print queue for that
same document.

If I do the same in MS Word, it just sends the document once with a copy
count of 3. This makes printing Excel documents frustratingly slow, as the
printer goes through initialisation routines each time a new document is
sent to it.

Why did MS do it this way? Is it a bug?


Thanks,
Alex Clark

 

[Mary Sauer]

Separate jobs are sent when you print or fax multiple copies in Excel
http://support.microsoft.com/kb/211474/en-us

 

[Alex Clark]

Fantastic, thankyou!

Separate jobs are sent when you print or fax multiple copies in Excel
http://support.microsoft.com/kb/211474/en-us

--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

 

[Rodney Bertsch]

Hello,

I have the opposite problem. In Word when I print a multiple page document
(5) for 4 copies, it spools 20 pages rather than 4 copies of 5 pages each.

This becomes a problem in two situations:

1) The main document is VERY large and spooling multiple copies ends up
with a HUGE spool file on the server, which has used all available disk space
on the server in the past. If it had went as one large file for multiple
files this would not have happened.

2) If we choose the staple option on the printer it staples the entire
batch since it went as one large job rather than several copies of a job.

I realize that sending the copies separatly may be slower, but we have some
situations where it would be a big benefit. Is there any way to change it?

Thanks,

Rodney

 

[StressMonkey]

You should be able to go into the Printer Properties and change whether you
want the job to spool and print while it spools or print when it's done or
even just print directly to printer.

Maybe once you change that, it will staple correctly. All of our printers
are set to print as it spools. Maybe that's why we can staple correctly?
I would imagine the printer would still know the end of the document and
where to staple.

Does this help at all?