Fix Excel Closing When Selecting a Function
Question details
Excel closes unexpectedly when the user types a function and selects it from the autocomplete list.

- 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.
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.
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.
Press Windows+R, enter excel /safe, and select OK. Try typing a function and selecting it from autocomplete.
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.
Return to File > Options > Add-ins, select Excel Add-ins under Manage, and select Go. Clear the checked add-ins and select OK.
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.

Update and repair Microsoft Office
Use this approach if the crash persists across workbooks or after add-ins are disabled.
Test a blank workbook and collect crash details
Determine whether the issue is limited to a workbook and gather information for Microsoft Support.
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.

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.




