printing from excel - print settings not applying to workbook

bigbmxdave

New Member
Joined
Mar 7, 2012
Messages
3
Afternoon all

I've got an annoying problem with my excel documents that I cant seem to fix.

I've got a workbook with several large medium sized sheets and
my printer is set to duplex by default,

if I go to file >> print I can go into printer properties and select single sided. However if I then try to print the entire workbook my new print settings only apply to the worksheet I am currently viewing. so the sheet I have open will print out single sided but all the others in the workbook will use the printer default settings and come out duplex.

Unfortunately setting the printer to single sided by default isnt an option.

Has anyone come across this issue before?

-Im using windows XPSP3
-Excel 2007 SP3
-The issue affects all excel workbooks

regards
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Morning All

I've tried several things such as readding the printer or recreating the .xlsx sheet,
the issue persists through all my printers.

Would anyone at least be able to test this on their installation to help me narrow down what could be causing it?

regards
 
Upvote 0

Forum statistics

Threads
1,214,613
Messages
6,120,515
Members
448,968
Latest member
Ajax40

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top