Fix Excel Freezing and Display Issues with Windows DPI Scaling
Question details
The user needs to resolve Excel freezing and incorrectly sized interface elements associated with Windows display scaling.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Working with large Excel workbooks at 100% or 125% display scaling, particularly when using external monitors.
- Observed behavior
- Excel freezes, and workbooks, formula bars, tabs, or scroll bars appear incorrectly sized.
Check Settings > System > Display to see the scaling setting for each connected monitor. Note whether the issue affects every workbook or only a particular file.
Override Excel's High-DPI Scaling Behavior
Use this setting to let Excel handle its own scaling when Windows display scaling causes freezing or sizing problems.
Close Excel, right-click its shortcut, and select Properties.
On the Compatibility tab, select Change high DPI settings.
Select Override high DPI scaling behavior, choose Application under Scaling performed by, and click OK to close the dialogs.
Reopen Excel and test the affected workbook on the monitor where the issue occurred.

Test Excel Without Add-ins
Use Safe Mode to check whether an add-in contributes to freezing or display problems.
Update or Repair Microsoft Office
Try an Office update or repair if the DPI override and add-in test do not resolve the issue.
Work with Excel Files in WPS Spreadsheet
If Excel's display issues interrupt your work, WPS Office is a free, lightweight alternative with a familiar interface. Open compatible Excel files in WPS Spreadsheet to make moving between applications easier.

Frequently Asked Questions
Where can I check Windows display scaling?
Open Settings > System > Display and select the relevant monitor. Look for Scale under Scale and layout.
Will the high-DPI override fix disappearing scroll bars?
It may improve Excel's scaling and performance, but disappearing scroll bars can still occur. Reopen the affected workbook after applying the override to check the result.
How can I tell if an add-in is causing Excel to freeze?
Press Windows + R, enter excel /safe, and open the affected workbook. If the problem does not occur in Safe Mode, use File > Options > Add-ins to disable and test add-ins.
What if only one workbook has the problem?
Compare it with other files by opening them in Excel. If only one workbook is affected, investigate that file separately rather than assuming the display scaling setting is the sole cause.




