Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Printing / January 2004

Tip: Looking for answers? Try searching our database.

Problem printing multiple copies in excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bat - 22 Jan 2004 02:38 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
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.