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
Best Answer
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.