Office Apps Crashing

Fix Excel Crashing When Selecting a Formula Suggestion

Khadija KhanKhadija Khan Nov 18, 2026 869 views

Question details

Find out why Excel crashes when a function is selected from the formula autocomplete list and how to resolve it.

Fix Excel Crashing When Selecting a Formula Suggestion
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.
Before you start

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.

Solution 1Recommended

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.

1
Start Excel in Safe Mode

Close Excel, press Windows+R, enter excel /safe, and select OK. In a blank workbook, type =COUNTIFS and select it from the suggestion list.

2
Check COM add-ins

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.

3
Check Excel add-ins

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.

4
Identify the conflict

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.

Test Excel in Safe Mode and disable add-ins
Temporary workaround: Until the crash is resolved, type the function manually or try inserting it through the Formulas tab.
Free Microsoft Office alternative

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.

Enter and edit spreadsheet formulas in WPS SpreadsheetsOpen and save Microsoft Excel XLSX and XLS filesUse a familiar interface for an easier transition from ExcelWork with a free, lightweight Office alternative
microsoft office alternative - wps office

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.