Printing Copies or multiple worksheets produces mult jobs

[BGW]

When I print multiple copies of a worksheet or I print an
entire workbook that contains multiple worksheets, Excel
breaks the print job up into multiple print jobs of
(apparently) random size. This creates a problem for
instance, when printing 2 sided because the
printer "resets" after the first print job and the
subsequent print jobs do not carry the requested
attributes (2 sided, in this case). Has anyone experienced
this problem. Any fixes? Thanks.

 

[Jay]

When I print multiple copies of a worksheet or I print an
entire workbook that contains multiple worksheets, Excel
breaks the print job up into multiple print jobs of
(apparently) random size. This creates a problem ...
... Any fixes? Thanks.

FinePrint might help:
http://www.fineprint.com/products/fineprint/index.html

Among its features is the ability to combine multiple print jobs into one.

 

[Guest]

Any suggestions, though, inside the MS world? We use a particular type of
copier/printer for our work because it's also a machine we sell (we did do
our sales proposals in booklet form until recently when that feature quit
working correctly for an unknown reason; hence, my post).

We want a solution that works either from within MSOffice or on the machine
itself, something we can promote to our customers.

Suggestions?

I found a fix to this problem, that works in Office 2000 anyway...

Each worksheet is created from a single worksheet.
Right click on the target worksheet, "Move or Copy", check "Make a Copy".

DON'T Insert->Worksheet.
DON'T populate more than a single worksheet that is to be printed from the
auto-generated ones.

Then format away. The result for me was a five page, single pdf, three
pages portrait, and two pages landscape (with graphics). Before applying
this trick, I had three individual pages (each as their own pdf) and a pair
of pages that had been copied one from the other (which was the clue)

Yes, it is a pain in the tush to copy the contents and the column widths
from existing speradsheets, but it does pay off...