Fix Excel Workbook Hangs and Slow Data Entry with Macros
Question details
Identify why Excel becomes unresponsive or slow during data entry in a workbook that contains macros.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user enters data in workbooks containing formulas or VBA code and wants to restore normal performance.
- Observed behavior
- Excel hangs or responds slowly during data entry, even before the user manually runs a macro, in both large and small workbooks.
Note whether the delay occurs in a new blank workbook as well as the affected file. If the workbook contains VBA, make sure you can identify its event procedures and know whether the code is trusted.
Test whether VBA event macros cause the slowdown
Use this test to check whether code that runs automatically during data entry is contributing to the delay.
In Excel for Windows, select File > Options > Trust Center > Trust Center Settings > Macro Settings.
Select the option to disable VBA macros with notification, save the setting, and reopen the affected workbook. Do not enable its macros when prompted.
Enter sample data in the same cells that were slow. If Excel responds normally with macros disabled, inspect the workbook's VBA event code.
Press Alt+F11 in Excel for Windows and inspect worksheet and ThisWorkbook code for procedures such as Worksheet_Change or Workbook_SheetChange. Review trusted code for repeated calculations, loops, or changes that trigger further events.
Check formulas and calculation settings
Use calculation settings to determine whether formula recalculation is slowing data entry.
Rebuild the Excel workbook and test components incrementally
Use this approach if the workbook remains slow or its settings, formulas, or VBA references are difficult to isolate.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative for everyday spreadsheet work, with a familiar interface and support for Microsoft Office formats to help you move existing files. It does not repair Excel's VBA behavior; check macro compatibility before relying on a macro-enabled workbook.

Frequently Asked Questions
Why can Excel slow down before I manually run a macro?
VBA event procedures can run automatically when cells change or other workbook events occur. In Excel for Windows, press Alt+F11 and inspect worksheet and ThisWorkbook code for event procedures.
How can I tell whether formulas are causing the delay?
Select Formulas > Calculation Options > Manual and test data entry. If it becomes faster, review the workbook's formulas and referenced ranges, then restore Automatic calculation and recalculate.
Does rebuilding the workbook prove the original file was corrupted?
No. If a rebuilt workbook works normally, the original may have had a problematic setting, formula, VBA reference, or corruption, but further testing is needed to identify the cause.
What file format should I use for the rebuilt workbook?
If it must retain VBA code, select File > Save As and choose Excel Macro-Enabled Workbook (*.xlsm).
Will disabling macros affect workbook features?
Yes. Features that depend on VBA will not run while macros are disabled. Test with macros disabled, then restore your preferred security setting and enable only trusted code.





