Fix Microsoft Excel Crashing When Entering Data in a Cell
Question details
The user needs to stop Microsoft Excel from crashing immediately after data is entered into a worksheet cell.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Entering or editing a value in an Excel worksheet cell.
- Observed behavior
- Excel closes, freezes, or crashes as soon as the user enters data into a cell.
Close Excel and restart the computer before testing further. If the problem occurs in one file only, make a copy of that workbook and test the copy so you can compare its behavior with a new blank workbook.
Start Excel in Safe Mode and disable problematic add-ins
Use this method first when Excel crashes during data entry, especially if the issue began after installing an add-in or integration.
Safe Mode starts Excel without most extensions and customizations. If typing works in Safe Mode, an Excel or COM add-in is likely causing the crash.
Close Excel. Hold down Ctrl while launching Excel, then select Yes when prompted to start Excel in Safe Mode. Alternatively, press Windows+R, enter excel /safe, and select OK.
Open a blank workbook in Safe Mode, select a cell, and type a short value. If Excel does not crash, continue by checking add-ins.
In Excel, select File > Options > Add-ins. At the bottom, choose Excel Add-ins from the Manage list and select Go. Clear all add-in check boxes, then select OK.
Go to File > Options > Add-ins, select COM Add-ins from the Manage list, and choose Go. Clear the selected add-ins, restart Excel normally, and re-enable add-ins one at a time to identify the cause.
Determine whether the workbook is damaged
Use this method when Excel crashes only in a particular workbook or sheet while other files accept data normally.
Update and repair Excel, Office, Windows, and graphics drivers
Use this method when Excel crashes in multiple workbooks, including blank files, or when Safe Mode does not resolve the problem.
Edit Excel Workbooks Reliably with WPS Spreadsheet
If Microsoft Excel continues to crash while you enter data, try WPS Office as a free, lightweight, and easy-to-use alternative. WPS Spreadsheet provides a familiar spreadsheet interface and supports seamless migration for common Excel workbook tasks.
Frequently Asked Questions
Why does Excel crash only when I type in a cell?
A crash during cell entry can be caused by an incompatible add-in, damaged workbook content, outdated Office components, graphics-driver issues, or limited available memory. Start Excel with excel /safe to check whether add-ins are involved.
How do I open Excel in Safe Mode?
Close Excel, press Windows+R, type excel /safe, and select OK. You can also hold Ctrl while opening Excel and confirm the Safe Mode prompt.
How can I tell whether an Excel add-in is causing the crash?
If Excel works in Safe Mode, go to File > Options > Add-ins. Select Excel Add-ins or COM Add-ins in the Manage list, choose Go, disable all add-ins, and then enable them individually after restarting Excel normally.
What should I do if only one Excel workbook crashes?
Open a blank workbook from File > New and test data entry. If only one file crashes, use File > Open > Browse, select the arrow beside Open, and choose Open and Repair. You can also copy usable sheets into a new workbook.
How do I repair a Microsoft Office installation for Excel crashes?
In Windows Settings, go to Apps > Installed apps, locate Microsoft 365 or Microsoft Office, select Modify, and run Quick Repair. If Quick Repair does not help, return to the same location and run Online Repair.
