Excel printed pages are different between two machines

I an excel spredsheet that I want to print from two different machines. On the first machine is printed on a single page where on the second needs two as the last line cannot fit on the first page.

I have installed the same drivers on both machines. The issue appears on all the following printers:

Microsoft XPS Document writer (Virtual printer)
PDF Writer - Bio pdf (Virtual printer)
Xerox Phaser 6121MFP (Physical printer)

I am aware that this is an old issue that can found on many technical forums but as of now there is no solution.

Details that are common across machines:

Windows ver 10.0.10240 (behavior was the same with windows 7)
MS office Professional plus 2010 ver 14.0.7162.50000 (64-bit)

Details that are different on the two machines

Machine 1: Lenovo T430U
Machine 2: Lenovo L540

pdf output machine 1 (OK)

pdf output machine 2 (Not OK)

xps output machine 1 (OK)

xps output machine 2 (Not OK)

Excel page settings

Excel margins

pdf settings

xps settings

thanos.a

Posted 2015-11-11T14:39:01.780

Reputation: 155

Have you set your print area? – Eric F – 2015-11-11T14:43:00.707

@EricF I have tried but I cannot see this to remedy the problem, unless I also select the zoom level to 95% which is something I want to avoid. – thanos.a – 2015-11-12T07:57:48.910

@downvoter I don't see the reason for the downvote to my post with is the more detailed of all in that old and unresolved issue. – thanos.a – 2015-11-12T07:58:57.733

Answers

This is an issue with the DPI setting. I'm guessing one computer is using 125% and one is using 100%.

This setting can be found by right clicking the desktop and looking at the display Settings and going under the "Scale and Layout" heading.

Excel is programmed by monkeys who apparently thought it was a good idea to tie the size of print items to the on screen DPI instead of to some independent number which is then scaled by the desired DPI for screen rendering.

Excel_Guy

Posted 2015-11-11T14:39:01.780

Reputation: 21

Seems a legitimate reason. – thanos.a – 2019-10-31T20:48:16.983

-2

Set your print area, then set Scaling to "Fit to 1 page(s) wide by 1 tall."

Marina Michaels

Posted 2015-11-11T14:39:01.780

Reputation: 22

1This will change the zoom level which something I want to avoid. The zoom level is a setting on the excel file which is common across the machines. This means that if that setting is saved the print out will be zoomed out in the other machine too. I am trying to find the reason of the problem which is why that machine considers the save worksheet not to fit to the same A4 page. – thanos.a – 2015-11-12T08:01:48.133