Fix Slow Filtering in Excel for Microsoft 365
Question details
Find out why filtering an 8,000-row workbook takes 20 to 30 seconds on one computer.

- Product
- Excel for Microsoft 365
- Device & OS
- Windows PC
- Scenario
- A corporate user filters a workbook that performs normally on other computers.
- Observed behavior
- Excel becomes unresponsive for 20 to 30 seconds during filtering, and starting Excel in Safe Mode does not resolve the delay.
Confirm that the same workbook filters normally on another computer and note whether it is stored locally or on a network. If this is a managed corporate PC, involve IT before changing system settings or testing another Windows profile.
Update Windows and test the affected PC
Use these checks to isolate a computer-specific issue when Excel Safe Mode does not help.
In Excel, select File > Account > Update Options > Update Now. If Office is already current, continue to the Windows checks.
Open Settings > Windows Update and select Check for updates. Install updates approved by your organization, restart the PC, and test the filter again.
With IT approval, open Settings > System > Recovery > Advanced startup, select Restart now, and choose Troubleshoot > Advanced options > Startup Settings > Restart. Select the Safe Mode option, then open a local copy of the workbook in Excel and test filtering.
Ask IT to sign in with another Windows user account on the affected PC, open the same workbook, and test its filter. A difference between profiles can help IT narrow down the cause.
Check Excel graphics and display settings
Test display-related settings if filtering remains slow on the affected PC.
Reduce workbook processing or use Power Query
Use this approach if the PC checks do not resolve the delay or the workbook has costly formulas and formatting.
Filter Workbooks with WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheets and use its filters for a seamless move between office suites.

Frequently Asked Questions
Why is the workbook slow only on one computer?
The difference points toward that PC's configuration rather than the workbook alone. Check Windows updates, display settings, graphics drivers, and another Windows user profile with help from IT.
Does Excel Safe Mode test the same things as Windows Safe Mode?
No. Excel Safe Mode limits Excel startup features, while Windows Safe Mode starts Windows with a limited set of drivers and services. Use Settings > System > Recovery > Advanced startup to access Windows Safe Mode.
Where can I turn off hardware graphics acceleration in Excel?
Open File > Options > Advanced and look under Display. The setting may not be available in every Microsoft 365 build or may be controlled by your organization.
Can Power Query make a large worksheet easier to filter?
Power Query can reduce the data loaded into Excel. Select Data > From Table/Range, filter out unneeded rows or columns in the editor, and choose Home > Close & Load.
What should IT do if another Windows profile is also slow?
Ask IT to compare the affected PC's drivers, graphics settings, and corporate configuration with a working PC. If appropriate, IT can consider restoring the corporate Windows image.




