Try selecting all sheets by right-click on first sheet tab and "Select all
sheets"

Set to single-sided for the group of sheets.

Then FilePrintActive Sheet(s)

Any better?


Gord Dibben MS Excel MVP

On Wed, 13 Feb 2008 14:04:02 -0800, MG2 wrote:

Hello, I have set up Double sided printing as the default on the server so
that all print jobs will be double-sided unless single sided printing is
requested. This is working fine.

I have one user, however, that regularly prints "Entire Workbook". When he
selects the "Entire Workbook" then sets the printer preferences for Single
sided printing, only the first page prints single-sided and all the rest of
the job is double sided.

Even after I control click on all the tabs in the workbook and set the page
setup options for the printer to single-sided - then return to the worksheets
separately - it defaults back to double-sided printing.

When I create a clean two page job in Word or Excel - it all works as
expected. But when choosing Entire Workbook it defaults back to whatever the
server printer driver is set to.

Is this a limitation of Excel?

MG2