Excel Performance Problems

Fix Excel Crashes When Filtering a Large Workbook

Bushra ParveenBushra Parveen Nov 22, 2026 868 views

Question details

Find out why Excel becomes unresponsive or crashes when filtering a large workbook.

Fix Excel Crashes When Filtering a Large Workbook
Product
Microsoft Excel
Device & OS
Windows
Scenario
A user filters a large workbook that works correctly for other users.
Observed behavior
Excel becomes unresponsive or crashes during filtering on one user's computer.
Before you start

Confirm that the workbook opens and filters correctly for another user, then note which filter triggers the crash. Close Excel before testing Safe Mode or changing startup files.

Solution 1Recommended

Test Excel Safe Mode and disable add-ins

Use Safe Mode to check whether an add-in or startup item is causing the crash.

1
Open Excel in Safe Mode

Hold Ctrl while launching Excel and confirm that you want to start in Safe Mode. Open the workbook and apply the same filter.

2
Check Excel add-ins

If filtering works in Safe Mode, restart Excel normally and go to File > Options > Add-ins. Select Excel Add-ins in the Manage box, click Go, and disable an add-in.

3
Check COM add-ins

Return to File > Options > Add-ins, select COM Add-ins in the Manage box, and click Go. Disable add-ins one at a time, restarting Excel and retesting the filter after each change.

Test Excel Safe Mode and disable add-ins
If Safe Mode also crashes: Continue with the printer, graphics, and Windows environment checks. A Safe Mode crash does not rule out every external cause.
Free Microsoft Office alternative

Try filtering the workbook in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format compatibility, making it easy to move existing workbooks into WPS Spreadsheets. It does not repair the underlying Microsoft Excel installation.

Filter spreadsheet data in WPS SpreadsheetsOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for an easy transitionAccess a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

How do I start Excel in Safe Mode?

Hold Ctrl while launching Excel, then confirm the Safe Mode prompt. Open the workbook and try the filter again.

Why does the workbook work for other users but crash on my computer?

Local add-ins, startup files, printer drivers, graphics settings, third-party services, or your Windows profile may differ. Test Excel in Safe Mode first, then check those local settings.

Should I delete everything in Excel's application data folder?

No. Close Excel and inspect the XLSTART folder at %appdata%\Microsoft\Excel\XLSTART. Temporarily move its files to a separate folder rather than deleting the entire Excel application data folder.

What if I cannot find the hardware graphics acceleration option?

The option varies by Excel version. If it is not under File > Options > Advanced > Display, skip that check and continue with the printer, clean boot, and profile tests.