Fix Excel Freezing During Data Entry and Switching Workbooks
Question details
The user needs to diagnose intermittent Excel data entry freezes and unexpected switches to another workbook.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Entering data while one or more Excel workbooks are open.
- Observed behavior
- Excel intermittently stops accepting data entry. Pressing Enter appears to restore functionality and may switch to another open workbook.
Note which workbooks, add-ins, and other applications are open when the freeze occurs. The Safe Mode and repair instructions below apply to Excel on Windows; menu names may vary by Office version.
Test Excel in Safe Mode and Isolate Add-Ins
Use Safe Mode and a blank workbook to check whether the issue is related to add-ins, startup behavior, or a particular file.
Close Excel, press Windows+R, enter excel /safe, and select OK. Open the affected workbook and test data entry.
If the issue does not occur in Safe Mode, reopen Excel normally and go to File > Options > Add-ins. Select COM Add-ins in the Manage list and click Go. Clear the selected add-ins, click OK, and test again. Re-enable them one at a time to identify a possible conflict.
Close other workbooks, then select File > New > Blank workbook and try entering data. Compare the result with the affected workbook.

Turn Off Automatic Flash Fill
Check whether Excel's automatic Flash Fill setting contributes to the data entry freeze.
Run an Online Repair of Microsoft Office
Repair the Office installation if the freeze continues after testing workbooks and settings.
Work With Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheet to continue working while you troubleshoot Microsoft Excel.

Frequently Asked Questions
How do I start Excel in Safe Mode?
On Windows, close Excel, press Windows+R, type excel /safe, and select OK. Then open a workbook and test data entry.
What should I do if Excel works normally in Safe Mode?
Reopen Excel normally and check add-ins under File > Options > Add-ins. Use the Manage list and Go button to disable COM add-ins, then re-enable them one at a time while testing.
Where can I turn off automatic Flash Fill?
In Excel, go to File > Options > Advanced. Under Editing options, clear Automatically Flash Fill and select OK.
How can I tell whether a workbook is causing the freeze?
Close other workbooks and test data entry in a new file using File > New > Blank workbook. Compare the result with the workbook where the issue occurs.
Will WPS Office repair my Excel installation?
No. WPS Office is an alternative for working with compatible spreadsheet files. To repair Excel on Windows, use the Microsoft 365 or Office Modify option in Settings > Apps and select Online Repair.




