Fix Excel Crashing When Selecting a Formula Suggestion
Question details
Find out why Excel crashes when a function is selected from the formula autocomplete list and how to resolve it.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user is entering a formula such as COUNTIFS and selects the function from Excel's suggestion list.
- Observed behavior
- Excel shuts down when the suggestion is selected, although manually typing the formula works.
Check whether Excel also crashes when you select a formula suggestion in a new blank workbook. The Safe Mode, repair, and event log instructions below are for Windows; menu names may vary by Office version.
Test Excel in Safe Mode and disable add-ins
Use this method to identify an Excel or COM add-in that may be interfering with formula suggestions.
Close Excel, press Windows+R, enter excel /safe, and select OK. In a blank workbook, type =COUNTIFS and select it from the suggestion list.
Restart Excel normally, then go to File > Options > Add-ins. Select COM Add-ins in the Manage list and click Go. Clear one add-in's check box, click OK, and test the suggestion list again.
Return to File > Options > Add-ins, select Excel Add-ins in the Manage list, and click Go. Disable add-ins one at a time and retest after each change.
If the crash stops after an add-in is disabled, leave it disabled and check its provider's website for an update. Re-enable unrelated add-ins using the same Manage dialog.

Update and repair the Excel installation
Try Office updates and repair if disabling add-ins does not stop the crash.
Check third-party utilities and Windows event logs
Use this method if Excel still crashes after add-in checks and repair.
Try WPS Spreadsheets as an Excel alternative
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheets to continue working with formulas while you troubleshoot Excel; it does not repair the Excel crash.

Frequently Asked Questions
Why does Excel crash when I select COUNTIFS but not when I type it?
The crash may be triggered by the autocomplete interaction rather than the formula itself. Test Excel in Safe Mode and check add-ins and third-party utilities for conflicts.
How do I start Excel in Safe Mode on Windows?
Close Excel, press Windows+R, type excel /safe, and select OK. Then try selecting a function from the autocomplete list.
Can I enter formulas without using the suggestion list?
Yes. Type the function manually, or try using Insert Function on the Formulas tab instead of selecting an autocomplete suggestion.
Should I uninstall HP Omen Gaming Hub?
It resolved the crash in one reported case, but it may not be the cause on every computer. First close it and test Excel; if you suspect a conflict, remove it through Windows Settings > Apps > Installed apps and test again.




