cannot print multi-sheet excel document two-sided using HP Laserjet 1320
which has duplex printing capabilities

probably a print driver issue rather than an Excel issue.
Re install the print driver

"kkm" wrote:

cannot print multi-sheet excel document two-sided using HP Laserjet 1320
which has duplex printing capabilities

thanks for the suggestion, reinstalling not working; probably doing
something wrong again. two sided printing works fine for single excel sheet
and for whole document of word. when i select two excel sheets on which
print areas have been defined, i expect print area on sheet 2 to print behind
printed area of sheet 1. the two defined areas just print individually. i
hope you can be of help "bj" thanks again.
"bj" wrote:

probably a print driver issue rather than an Excel issue.
Re install the print driver

"kkm" wrote:

cannot print multi-sheet excel document two-sided using HP Laserjet 1320
which has duplex printing capabilities

I misunderstood your original question. Each sheet will print as a separate
job and will not do double sided for multiple worksheets only multiple pages
in one worksheet..
A work around is to make a maste print worksheet which has the appropriate
info from each of the other sheets. this will double side.

"kkm" wrote:


thanks for the suggestion, reinstalling not working; probably doing
something wrong again. two sided printing works fine for single excel sheet
and for whole document of word. when i select two excel sheets on which
print areas have been defined, i expect print area on sheet 2 to print behind
printed area of sheet 1. the two defined areas just print individually. i
hope you can be of help "bj" thanks again.
"bj" wrote:

probably a print driver issue rather than an Excel issue.
Re install the print driver

"kkm" wrote:

cannot print multi-sheet excel document two-sided using HP Laserjet 1320
which has duplex printing capabilities

May I post a related question? yesterday I succesfully printed a double
sided 4 page excel document with an HP psc 750 (multifunction) printer.
Today I can't do it. The print window looks different and no longer has the
provision for selecting "two sided printing". I didn't comprehend the
previous solution. Thank for any advice. Xerxes

"bj" wrote:

I misunderstood your original question. Each sheet will print as a separate
job and will not do double sided for multiple worksheets only multiple pages
in one worksheet..
A work around is to make a maste print worksheet which has the appropriate
info from each of the other sheets. this will double side.

"kkm" wrote:


thanks for the suggestion, reinstalling not working; probably doing
something wrong again. two sided printing works fine for single excel sheet
and for whole document of word. when i select two excel sheets on which
print areas have been defined, i expect print area on sheet 2 to print behind
printed area of sheet 1. the two defined areas just print individually. i
hope you can be of help "bj" thanks again.
"bj" wrote:

probably a print driver issue rather than an Excel issue.
Re install the print driver

"kkm" wrote:

cannot print multi-sheet excel document two-sided using HP Laserjet 1320
which has duplex printing capabilities