Fix Excel Crashes When Filtering a Large Workbook
Question details
Find out why Excel becomes unresponsive or 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.
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.
Test Excel Safe Mode and disable add-ins
Use Safe Mode to check whether an add-in or startup item is causing the crash.
Hold Ctrl while launching Excel and confirm that you want to start in Safe Mode. Open the workbook and apply the same filter.
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.
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.

Check Excel startup files, the default printer, and graphics settings
Use these checks to isolate settings or files that can affect Excel on one computer.
Test Windows services and a new user profile
Use a clean boot and a separate Windows account to identify conflicts outside Excel.
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.

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.




