Excel Performance Problems

Fix Excel Freezing When Zooming or Pasting Large Data

Anum MushtaqAnum Mushtaq Nov 18, 2026 870 views

Question details

The user needs to identify why desktop Excel freezes when working with large data, conditional formatting, or a low zoom level.

Fix Excel Freezing When Zooming or Pasting Large Data
Product
Microsoft Excel for desktop
Device & OS
Windows
Scenario
The user pastes hexadecimal data, applies conditional formatting, or zooms a workbook to 10%.
Observed behavior
Excel freezes on one computer, while the same files work on other computers and in Excel for the web.
Before you start

Note the exact action that causes the freeze and check whether the same workbook works in Excel for the web or on another computer. If possible, prepare a small sample that reproduces the issue.

Solution 1Recommended

Test Excel in Safe Mode and check COM add-ins

Use Safe Mode to check whether an add-in or another startup customization contributes to the freeze.

1
Start Excel in Safe Mode

Close Excel, press Windows+R, enter excel.exe /safe, and select OK.

2
Repeat the action

Open the affected workbook in Excel and try the same paste, conditional-formatting, or zoom action.

3
Check COM add-ins

If the issue does not occur in Safe Mode, restart Excel normally. Go to File > Options > Add-ins, select COM Add-ins in the Manage box, and select Go.

4
Isolate an add-in

Clear the check boxes for third-party add-ins, select OK, and retest. Re-enable them one at a time to identify a possible cause, then update or remove the affected add-in.

Test Excel in Safe Mode and check COM add-ins
If Safe Mode still freezes: Continue with the update and workbook checks. A freeze in Safe Mode does not by itself identify the cause.
Free Microsoft Office alternative

Try WPS Spreadsheet as an Excel Alternative

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheet to continue working while you troubleshoot the local Excel issue and migrate files with less disruption.

Open and edit compatible Microsoft Excel XLSX and XLS filesWork with spreadsheet data, zoom controls, and conditional formattingUse a familiar interface that makes switching from Office easierGet a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does the workbook work in Excel for the web but freeze on my computer?

The difference points to a possible local desktop factor, such as an add-in, Excel build, graphics driver, or display configuration. Start Excel with Windows+R > excel.exe /safe, then compare updates and display settings.

How do I find out whether an add-in is causing the freeze?

Test the workbook in Safe Mode using excel.exe /safe. If the freeze stops, restart Excel normally and go to File > Options > Add-ins > Manage: COM Add-ins > Go. Disable third-party add-ins and re-enable them one at a time.

Can conditional formatting slow down zooming or pasting?

Many rules or rules applied to unnecessarily large ranges can increase workbook processing. Go to Home > Conditional Formatting > Manage Rules to review the rules and their Applies to ranges.

Where can I find my Excel build number?

In Excel, open File > Account > About Excel to find the version and build. Include this information when comparing computers or asking for help.

What should I share if Excel still freezes?

Share a small sample workbook, such as a 50-by-50 data sample, through OneDrive or another file-sharing service. Include the workbook structure, Excel build, display setup, and the exact paste, formatting, or zoom steps that reproduce the issue.