Fix Excel Crashes or Sign-Outs When Entering Formulas
Question details
The user needs to identify why Excel crashes or signs them out when they enter formulas or functions.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Entering formulas or functions in an Excel workbook.
- Observed behavior
- Excel crashes or signs the user out when formulas or functions are entered.
Record your Excel version, operating system, workbook location, exact formula and any error message. Note whether the issue occurs in one workbook or in a new blank workbook.
Test Excel in Safe Mode and Check Add-ins
Use this Windows-specific test to see whether an add-in is contributing to the crash or sign-out.
On Windows, press Windows+R, enter excel /safe, and select OK.
Open the affected workbook and enter the same formula. Also try a simple formula such as =1+1 in a new blank workbook.
If Excel works in Safe Mode, restart it normally and go to File > Options > Add-ins. Next to Manage, select COM Add-ins, choose Go, clear the add-in checkboxes, and select OK. Repeat for Excel Add-ins if needed.
Restart Excel and test the formula. If the issue is gone, re-enable add-ins one at a time through File > Options > Add-ins, testing after each one.

Update Office and Repair Microsoft 365
Use this option if the issue persists without add-ins or affects multiple workbooks.
Isolate the Workbook or Formula
Use this test to determine whether the behavior is limited to a particular file, formula or storage location.
Work With Spreadsheet Formulas in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Its Microsoft Excel format compatibility helps you move existing files into WPS Spreadsheets; it does not repair Microsoft Excel.

Frequently Asked Questions
How do I check whether an Excel add-in is causing the crash?
On Windows, press Windows+R, enter excel /safe, and test the formula. If the issue does not occur, restart Excel normally and disable add-ins under File > Options > Add-ins, then re-enable them one at a time.
What if Excel only crashes in one workbook?
Try the same formula in File > New > Blank workbook. If only the original file is affected, note its storage location and test a local copy made through File > Save As.
Where can I find my Excel version?
In Excel on Windows, open File > Account and look under Product Information or About Excel. On a Mac, open Excel > About Excel.
What should I include when reporting the sign-out or crash?
Include your Excel version, operating system, workbook location, exact formula and steps, and any error message. A sample workbook with sensitive information removed can also help someone reproduce the issue.




