Excel Performance Problems

Fix Excel Workbook Hangs and Slow Data Entry with Macros

Emma BrownEmma Brown Nov 18, 2026 868 views

Question details

Identify why Excel becomes unresponsive or slow during data entry in a workbook that contains macros.

Fix Excel Workbook Hangs and Slow Data Entry with 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.
Before you start

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.

Solution 1

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.

1
Open macro settings

In Excel for Windows, select File > Options > Trust Center > Trust Center Settings > Macro Settings.

2
Disable macros for the test

Select the option to disable VBA macros with notification, save the setting, and reopen the affected workbook. Do not enable its macros when prompted.

3
Test data entry

Enter sample data in the same cells that were slow. If Excel responds normally with macros disabled, inspect the workbook's VBA event code.

4
Review event procedures

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.

Keep macro security in mind: Disabling macros can prevent workbook features from working. Restore your preferred security setting after testing, and enable code only when you trust its source.
Free Microsoft Office alternative

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.

Enter and review spreadsheet data in a familiar interfaceOpen and edit compatible Microsoft Excel XLSX filesUse a free, lightweight office suite for everyday tasksMove existing spreadsheets into WPS Office without starting from scratch
microsoft office alternative - wps office

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.