Printing

[Richard]

I've got Excel 97 and a Kyocera 1020D printer.The printer is set to
automatic duplex. I've got 5 sheets in a workbook. Printing should put the
even sheets (2 & 4) on the back of pages 1 and 3 respectively. Sheet 2
prints on the back of sheet 1, but sheet 4 fails to print on the back of
sheet 3. It seems that after page 2, automatic duplex does not want to work.
Don't know if it's the printer, or Excel. I've checked with print preview,
that each sheet does print only one page, not a page, then a blank page.
TIA.

 

[Richard]

I've got Excel 97 and a Kyocera 1020D printer.The printer is set to
automatic duplex. I've got 5 sheets in a workbook. Printing should
put the even sheets (2 & 4) on the back of pages 1 and 3
respectively. Sheet 2 prints on the back of sheet 1, but sheet 4
fails to print on the back of sheet 3. It seems that after page 2,
automatic duplex does not want to work. Don't know if it's the
printer, or Excel. I've checked with print preview, that each sheet
does print only one page, not a page, then a blank page. TIA.

I mean to say: Sheet 2 prints on the back of page 1, but sheet 4
fails to print on the back of page 3.

 

[Ron de Bruin]

Hi Richard

I don't have a printer like you so I use a macro to
print Odd and Even pages
http://www.rondebruin.nl/print.htm#odd

Maybe a work around for you till you got a solution