Odd... I am trying to print multiple copies but Excel is sending the job
as x separate copies rather than 1 copy with the instructions for the
PRINTING to print x copies.
I've never seen a program do this before. Can this be turned off in
Excel and consequently made so that it does what it's supposed to? Send
ONE copy and a printer command with how many copies to make?
bat
Paul Cundle - 22 Jan 2004 21:08 GMT
Excel will even send separate sheets of the same workbook as different print
jobs sometimes (depending on certain print settings of each sheet).
Therefore the chances of persuading it to do multiple copies as a single
job - which I believe is what you are asking - are likely to be nil I'm
afraid.
Paul C,

Signature
> Odd... I am trying to print multiple copies but Excel is sending the
> job as x separate copies rather than 1 copy with the instructions for
[quoted text clipped - 9 lines]
> ------------------------------------------------------------------------
> View this thread: http://www.mcse.ms/message309620.html
bat - 23 Jan 2004 02:00 GMT
Amazing - I've never seen a program do this before. The implications of
possible problems are staggering such as overflow jobs in the spooler,
printer memory overflow, spool file overload, etc...
There must be a fix for this.... wow...
bat
bat - 24 Jan 2004 02:16 GMT
That did it!
Unchecking 'Collate'.
Nice one
ba
Jess Feinman - 23 Jan 2004 04:56 GMT
> Odd... I am trying to print multiple copies but Excel is sending the job
> as x separate copies rather than 1 copy with the instructions for the
[quoted text clipped - 9 lines]
> ------------------------------------------------------------------------
> View this thread: http://www.mcse.ms/message309620.html
Bat:
Try unchecking the "collate" box. HTH.
Jess