Excel printing and display scaling bug

Anonymous
2018-04-10T15:17:07+00:00

Windows 7 Pro

Office 365 x64 ver 1709 (Build 8431.2236 click-torun)

When printing with Excel, the page layout is being affected by display scaling.  I had it set at 125%.  A spreadsheet that normally prints to 6 pages is trying to print to 9 or 10 pages.  Adjusting the page size in "page break view" does not fix the problem.  This is with the setting, "fit all columns on one page".  If you simply reduce the *print* scaling (by a percentage, instead) until it print on only 6 pages, the sheet appears more narrow than it normally does.

If you simply set the display scaling back to 100%, it fixes the problem.  Display scaling should only change what I see, not how it prints.

Furthermore, checking the box under excel shortcut:  "disable display scaling on high dpi settings" does NOT disable the display scaling for excel like it should.  I had to completely shut it off under display settings to resolve the problem.

Edit:  Added *print* to the scaling option I was referring to.   Please note display scaling setting is in windows and print scaling is in excel.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

79 answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2018-05-25T01:17:19+00:00

    Even in windows 10, the DPI settings do not fully take effect until you sign out of your profile and sign back in.

    I tested without signing out, and the problem does not occur.  Excel also does not look very sharp until you sign out and sign back in.  I retested after signing out and the problem still happens.

    You need to sign out in order to reproduce the trouble. please try this.

    It might also be worth it for you to try it out on a machine with an nvidia video card.  Both machines I have are using them... and the problem is obviously somehow related to video settings.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2018-05-24T04:52:43+00:00

    Hi Matthew,

    Thanks for your detailed information.

    I have tested the file you provided and can't repro this issue on our side now. Since the issue also happens to your Win10 machine, could you please provide a video reproduced in Win10 machine via PM for our check? Because within it, we can involve the related team to keep assisting you on this issue.

    By the way, when changing display settings in Win10, you don't need to log off the account.

    We appreciate your patience and effort.

    Sky

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-05-22T15:17:36+00:00

    This was on my work PC.  It won't be upgraded till later this year.  I used my test file on my home machine.  It has 32 bit office, and windows 10 pro 64 bit.  Exactly the same results as above.  Page one is different.  Please note I also tried 150% DPI and same data shows on page 1 as 125% DPI.

    So,

    different PC,

    different OS,

    different office,

    same problem.

    I couldn't get a screenshot to upload, so link to onedrive file below.

    Office version

    (PII is masked by forum moderator)

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments
  4. Anonymous
    2018-05-16T05:04:08+00:00

    Hi Matt,

    Do you still encounter that issue after you upgrade to Windows 10? Feel free to share the status at your convenience. We will be glad and continue to provide support for you until it is fixed.

    Regards,

    Zixuan

    Was this answer helpful?

    0 comments
  5. Anonymous
    2018-05-14T01:31:07+00:00

    Hi CW2019,

    Your questions are similar, but the Office products you use are different. Since we tested with the same Office product in same version as Matt but failed to repro and the issue wasn’t fixed after Matt tried the troubleshooting steps, we provided the above suggestion. Regarding to the issue you encountered, we kindly suggest you focus on your thread. The related engineer will provide dedicated support for you there.

    We appreciate your understanding.

    Best Regards,

    Zixuan

    Was this answer helpful?

    0 comments