Excel changing paper size

ChelseaZ

New Member
Joined
Jun 21, 2023
Messages
8
Office Version
  1. 2019
Platform
  1. Windows
I'm running Excel Standard 2016. I have a particular file which I need to print in color sometimes, which means I change from my default HP printer to a color Xerox down the hall. When I change back to my default printer, it changes the paper size to Oficio 8.5 x 13. The HP printer has letter size printer as it's default settings in Properties. I end up having to change the paper size several times a week which isn't the end of the world but it is annoying, more so because I can't figure out WHY it is doing it. I do have other files that I do the same thing (change printers) but they don't change size. The only difference that I can see is that this file is setup for landscape printing.

Is there some obscure setting somewhere in the file or in VBA that might be doing this that I could change?
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Hit Windows key and type Settings. Open System Settings. Click on Bluetooth and Devices. Scroll down to Printer and Scanners. Click on it. Scroll down to Printer Preferences. Is "Let Windows manage my Default printer active?
 
Upvote 0
No, that box is not checked -- do you think that would help? I have the printer at my desk set as default.
 
Upvote 0
Well I tried setting and unsetting the "Let Windows manage my Default printer" and it doesn't make a difference to this problem. One new thing I found that I think is the reason but I don't know if there is a solution or workaround, is that when I change to the Xerox printer down the hall, it changes the paper type to 8.5x11 LEF and when I change back to the HP, there is just regular letter, not LEF. Anyone have any recommendations?
 
Upvote 0

Forum statistics

Threads
1,224,465
Messages
6,178,820
Members
452,881
Latest member
motivationgyan

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