Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / March 2008

Tip: Looking for answers? Try searching our database.

Excel Workbook printing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MG2 - 13 Feb 2008 22:04 GMT
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
Gord Dibben - 14 Feb 2008 02:11 GMT
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 File>Print>Active Sheet(s)

Any better?

Gord Dibben  MS Excel MVP

>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
[quoted text clipped - 16 lines]
>
>MG2
MG2 - 14 Feb 2008 15:36 GMT
Thanks Gord,

That looked really promising. Unfortunately, even after selecting all
sheets, configuring the page options to single-sided, then selecting all
sheets again, then printing active sheets - we still get the first page
single sided, the rest double-sided.

I think I will just have to create a single-sided printer on the print server.

However, I'm surprised that Excel cannot do this.

Marcina

> Try selecting all sheets by right-click on first sheet tab and "Select all
> sheets"
[quoted text clipped - 27 lines]
> >
> >MG2
looneylmt - 27 Mar 2008 22:57 GMT
Have you tried changing it in the page setup? Also when the printer page pops
up, click the properties tab. I do this and have no problem changing what I
want to print. It could be the properties in the printer set up that you need
to change.

> Thanks Gord,
>
[quoted text clipped - 40 lines]
> > >
> > >MG2
MG2 - 27 Mar 2008 23:13 GMT
Thanks but the solution that finally worked for me was to create another
printer on the print server - with single sided printing. Then, when the
client wanted to print single sided "whole" workbooks, they would just print
to the single-sided printing.

Nothing I did in Excel worked.
Thanks,
Marcina

> Have you tried changing it in the page setup? Also when the printer page pops
> up, click the properties tab. I do this and have no problem changing what I
[quoted text clipped - 45 lines]
> > > >
> > > >MG2

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.