Excel Performance Problems

Fix Excel Freezing During Data Entry and Switching Workbooks

Chanuka GeekiyanageChanuka Geekiyanage Nov 18, 2026 870 views

Question details

The user needs to diagnose intermittent Excel data entry freezes and unexpected switches to another workbook.

Fix Excel Freezing During Data Entry and Switching Workbooks
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Excel in Safe Mode

Close Excel, press Windows+R, enter excel /safe, and select OK. Open the affected workbook and test data entry.

2
Test add-ins

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.

3
Test a blank workbook

Close other workbooks, then select File > New > Blank workbook and try entering data. Compare the result with the affected workbook.

Test Excel in Safe Mode and Isolate Add-Ins
Intermittent behavior: The issue may take time to recur. Record which files and applications are open during each test.
Free Microsoft Office alternative

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.

Edit spreadsheet data in a familiar interfaceCompatible with Microsoft Excel XLS and XLSX formatsFree, lightweight Office alternativeOpen existing files to make switching tools easier
microsoft office alternative - wps office

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.