Solved

landscape printer setting overwritten by offiice programs

Posted on 2010-08-23
16
786 Views
Last Modified: 2013-12-15
I've changed the default printer settings for a printer on the print server to landscape.  However,  office applications  switch back to default orientation when selecting print.  I don't want to have to select landscape everytime we print financial reprots.  Please assist
0
Comment
Question by:snoopaloop
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 5
  • 2
  • +1
16 Comments
 
LVL 20

Expert Comment

by:woolnoir
ID: 33504833
This is normally due to the fact that office document settings override the default layout settings in the print driver. Are the defaults for the document set correctly i.e ?

Start Word/Excel and open the document you want to change.
Click the Paper tab, you can do that according to the version of MS Office that you are using.
Under Paper, click the paper size you want.
If you want to change the page orientation of the document or its page margins, click the Margins tab.
Select the desired options.
To use the paper size specified in step 4 for only the active section of the document, click Selected text.
Click OK.
0
 
LVL 20

Expert Comment

by:woolnoir
ID: 33504844
0
 
LVL 1

Author Comment

by:snoopaloop
ID: 33504925
I tried in Excel 2010 and the settings are saved for that particular excel file but not as a default excel setting.  In short, landscape is not saved by default for printing.
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 20

Expert Comment

by:woolnoir
ID: 33504952
You need to alter the default document template for the orientation you want... office overrides the printer default that behaviour cant be changed AFAIk - the default templace for each document type can be changed.


Open a new workbook.  Customize as you wish including your print
settings.........group the sheets before setup so's all sheets get same
setup.

File>Save As Type:  scroll down to Excel Template(*.XLT) and select.  Name
your workbook "BOOK"(no quotes). Excel will add the .XLT to save as
BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for File>New or the Toolbar button
File>New or CTRL + n

WARNING................Do not use File>New...Blank Workbook or you will get
the Excel default workbook.

NOTE:  Existing workbooks are not affected by these settings.

You can also open a new workbook and delete all but one sheet.  Customize as
you wish then save this as SHEET.XLT in XLSTART folder also.  It now becomes
the default Insert>Sheet.
0
 
LVL 38

Expert Comment

by:hdhondt
ID: 33506746
Word and Excel save printer settings with the document. For Word, you can even have different paper sizes and orientations for different parts of the document.

However, both Word and Excel will start a new document with the current printer settings. That means that if you restart the application, the current default printer settings will be in effect. If your default printer driver is set to landscape, that's how they will start.
0
 
LVL 1

Author Comment

by:snoopaloop
ID: 33513036
That's not true.  Iv'e printed in landscape, closed the app, and went back to the existing spreadsheet only to find that the printer setting is no longer landscape.
0
 
LVL 1

Author Comment

by:snoopaloop
ID: 33513037
That's not true.  Iv'e printed in landscape, closed the app, and went back to the existing spreadsheet only to find that the printer setting is no longer landscape.
0
 
LVL 20

Expert Comment

by:woolnoir
ID: 33513138
You need to alter the default document template for the orientation you want... office overrides the printer default that behaviour cant be changed AFAIk - the default templace for each document type can be changed.

^^^

The behaviour is simple

The order of preference is

Printer -> Template -> Document.

WHen you set the printer the settings are law, unless the template says different. The template (normally set to portrait) sets the default page type for every document it creats. Each document has a setting in page prefs....

The best way.. dont set on the printer, change the template to landscape (if thats what you want) and change any documents already created to landscape... this should sort it.

Its not about what you PRINT to, its about what the PAGE is setup as, if the document is set to portraite, you can print to landscape but when you restart it will be set to portrait again. You need to set the PAGE (word) or SHEET (excel) which controls by default how it prints.
0
 
LVL 1

Author Comment

by:snoopaloop
ID: 33513349
Is this only for new docs or workbooks?  we will be pulling from a database that will be imported into excel
0
 
LVL 20

Expert Comment

by:woolnoir
ID: 33513366
Any existing docs will need to be changed manually AFAIk - the setting for all new docs is controlled by the template... is this of any use for you ?
0
 
LVL 21

Expert Comment

by:wyliecoyoteuk
ID: 33514371
One thing with excel, is that changes made in the print preview mode are saved with the document.
In Word, (tools>options>print in2003) set the print default to "use printer settings", and the application settings will not override the printer settings
0
 
LVL 20

Expert Comment

by:woolnoir
ID: 33530837
Did you have any luck with this ? any of the suggestions help ?
0
 
LVL 1

Author Comment

by:snoopaloop
ID: 33533368
So excel 2010 existing imported data on to a spreadsheet needs to be altered manually by something called AFAlk?  Not exactly the answer I was hoping but the answer none the less.
0
 
LVL 20

Accepted Solution

by:
woolnoir earned 63 total points
ID: 33533428
AFAIK = as far as I know. The problem is that if existing docs have been created with their defaults set as portrait, then the it will generally print to the printer as such unless you set it manually.

so yeah, set your template to portrait and it should fix all future documents.
0
 
LVL 21

Assisted Solution

by:wyliecoyoteuk
wyliecoyoteuk earned 62 total points
ID: 33536776
The problem is that settings are saved with the document, and application page setup settings override print driver settings.
A common problem  is that windows defaults to American sizes (letter,etc), we have constant issues when our customers have letter as the default paper size and try and print to A4 printers.
0
 
LVL 20

Expert Comment

by:woolnoir
ID: 33556885
@snoopaloop any further progress on this one, did we find the solution, explain the situation, or did you want more assistance ?
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question