'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Sort and Filter Not Working in Normal Mode
Question details
The user needs to fix an issue where sorting and filtering features in Microsoft Excel freeze or fail to respond in Normal Mode, despite functioning correctly in Safe Mode.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Attempting to sort or filter spreadsheet data in normal operating conditions.
- Observed behavior
- Sort and filter options stop responding in Normal Mode, even after a full Office reinstallation, but continue to work flawlessly when Excel is booted in Safe Mode.
Before proceeding with these troubleshooting steps, ensure you have saved all open workbooks. If you plan to reset registry keys, it is highly recommended to back up your Windows Registry first.
Disable Conflicting Add-ins and Hardware Acceleration
Since Excel works correctly in Safe Mode, third-party add-ins or hardware graphics acceleration settings are the most likely causes for features freezing in Normal Mode.
Safe Mode starts Excel without loading startup files, add-ins, or advanced graphics configurations. By disabling these manually in Normal Mode, you can isolate the component causing the malfunction.
Open Excel, click on 'File', and select 'Options'. Navigate to the 'Advanced' tab on the left. Scroll down to the 'Display' section and check the box for 'Disable hardware graphics acceleration'. Click 'OK'.
Go back to 'File' > 'Options' and click on 'Add-ins' from the left sidebar.
At the bottom of the window, ensure the 'Manage' dropdown is set to 'COM Add-ins' and click 'Go'. Uncheck all non-essential add-ins in the list and click 'OK'. Restart Excel to test the Sort and Filter functions.
Run a Microsoft Office Online Repair
An Online Repair can fix corrupted Office installation files or background services that a standard reinstallation might overlook.
Test with a New Windows Profile or Reset Registry
If the problem persists, it may be tied to a corrupted Windows user profile or deeply ingrained Excel registry settings.
Try WPS Office for a Stable and Seamless Spreadsheet Experience
If Microsoft Excel continues to freeze during data sorting and filtering, consider switching to WPS Office. It provides a lightweight, highly compatible alternative with powerful data analysis tools that work smoothly out of the box, without requiring complex registry troubleshooting or safe mode diagnostics.
- 1. Download and Install: Get the free WPS Office suite from the official website and complete the quick installation.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing .xlsx or .csv files directly.
- 3. Sort and Filter Data: Navigate to the 'Data' tab on the top ribbon to access the Sort and AutoFilter tools without lag or crashes.
Frequently Asked Questions
Why does Excel Sort and Filter work in Safe Mode but not Normal Mode?
Safe Mode forces Excel to run in its most basic state by bypassing third-party add-ins, custom toolbar settings, hardware acceleration, and certain registry configurations. If features work in Safe Mode, it directly indicates that one of these bypassed elements is corrupted or conflicting in Normal Mode.
How do I quickly open Microsoft Excel in Safe Mode?
You can launch Excel in Safe Mode by holding down the CTRL key on your keyboard while clicking the Excel shortcut. Alternatively, you can press Win + R to open the Run dialog, type 'excel.exe /safe', and press Enter.
Will reinstalling Microsoft Office fix Normal Mode crashes?
Not always. A standard uninstallation often leaves behind user-specific settings, corrupted profiles, and registry keys. If an issue is tied to your profile configuration, reinstalling the software will simply reload the same corrupted settings. Running an Online Repair or resetting the registry is usually more effective.
How do I know if hardware acceleration is causing Excel to freeze?
Hardware acceleration offloads graphics rendering to your computer's GPU. If your graphics drivers are outdated or incompatible, it can cause Excel features like sorting, filtering, or scrolling to freeze. Disabling the feature via File > Options > Advanced > Display is the easiest way to test this.
