Printing several worksheets in duplex

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stefano Gatto - 27 Jun 2006 16:02 GMT

Hello.

I wanted to print an entire workbook of 14 worksheets on 7 physical pages,
i.e. one worksheet per page side. Worksheets have little amount of data
always fitting on one page, so there it is expected that the total number of
physical pages is 7.

I tried this on several duplex printers (HP, Lanier) we have in the office
and all were unable to accomplish this. The workbook printed on 14 physical
pages, each page showing one worksheet.

Is there a setting in Excel that prevents from printing two worksheets on
one single physical page?

The strange thing is that I was able to print the way I want from 1998 to
recently and then, since I changed PC (Win XP SP1/XL03 SP2) one month ago
this doesn't work anymore.

Note that on these printers printing in duplex works fine, since I have
tried to print a 200-line worksheet and it came out in duplex, as expected.
So it's NOT a driver problem!

Stefano Gatto

Reply to this Message

Stefano Gatto - 04 Jul 2006 14:13 GMT

Strange. The next day I posted this, I tried again and the worksheet printed
in duplex, the way I wanted... I personally did not change any of the
settings/drivers/Excel/Windows, but now it works.
Another colleague still could not print in duplex, so I explored Internet
and finally found someone writing that unchecking the Collate option in the
print dialog box would solve the problem. So I did this on her PC and now she
can also print in duplex! To me understanding "Collating" has NOTHING to do
with duplexing, but this is the way it is. Funny though, on my PC that
option is irrelevant for the duplexing issue (but governs the collating
aspect successfully - hopefully), while it is determinant on my colleagues
PC...!

And we both print on the same printer with the same driver!

Stefano Gatto

> Hello.
>
[quoted text clipped - 19 lines]
>
> Stefano Gatto

Reply to this Message