Office Apps Crashing

Fix Excel Closing When Selecting a Function

Olivia MillerOlivia Miller Nov 18, 2026 869 views

Question details

Excel closes unexpectedly when the user types a function and selects it from the autocomplete list.

Fix Excel Closing When Selecting a Function
Product
Microsoft Excel
Device & OS
not provided
Scenario
Entering a formula and selecting a suggested function such as SUM.
Observed behavior
Excel closes when a function is selected from the autocomplete list.
Before you start

Note whether the crash happens in one workbook or several, and whether it occurs with a particular function. The Safe Mode, repair, and Event Viewer steps below apply to Excel on Windows.

Solution 1Recommended

Start Excel in Safe Mode and check add-ins

Use Safe Mode to see whether an add-in or startup setting is involved, then test add-ins individually.

1
Open Excel in Safe Mode

Press Windows+R, enter excel /safe, and select OK. Try typing a function and selecting it from autocomplete.

2
Disable COM add-ins

If Excel stays open in Safe Mode, restart it normally. Go to File > Options > Add-ins, select COM Add-ins under Manage, and select Go. Clear the checked add-ins and select OK.

3
Disable Excel add-ins

Return to File > Options > Add-ins, select Excel Add-ins under Manage, and select Go. Clear the checked add-ins and select OK.

4
Identify the add-in

Restart Excel and test autocomplete. If the crash stops, re-enable add-ins one at a time from the relevant Add-ins dialog, restarting and testing after each change.

Start Excel in Safe Mode and check add-ins
If Safe Mode does not help: A crash in Safe Mode does not rule out other causes. Continue by testing a blank workbook and repairing Office.
Free Microsoft Office alternative

Work with spreadsheet formulas in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and continue working with formulas while troubleshooting Microsoft Excel.

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

Frequently Asked Questions

Why does Excel stay open in Safe Mode?

Safe Mode limits add-ins and some startup settings. If the crash stops, check COM Add-ins and Excel Add-ins under File > Options > Add-ins and test them individually.

How can I tell if only one workbook is affected?

Select File > New > Blank workbook and try the same function autocomplete action. If the blank workbook works but the original closes Excel, the issue may be specific to the original file.

Where can I find details about the Excel crash?

On Windows, open Event Viewer and go to Windows Logs > Application. Look for an Error event at the time of the crash and open it to view the faulting module and exception details.

What should I do if Quick Repair does not stop the crash?

Return to Windows Settings > Apps, find Microsoft 365 or Office, and choose Modify. Select Online Repair if it is available, then test Excel again.