Office Apps Crashing

Fix 64-Bit Excel Freezing When Opening a Macro-Enabled Workbook

Bushra ParveenBushra Parveen Nov 22, 2026 868 views

Question details

Determine why a macro-enabled workbook opens in 32-bit Office but causes 64-bit Excel to stop responding.

Fix 64-Bit Excel Freezing When Opening a Macro-Enabled Workbook
Product
Microsoft Excel for Microsoft Office
Device & OS
not provided
Scenario
Opening a macro-enabled workbook in 64-bit Excel.
Observed behavior
Excel stops responding when the workbook opens. Disabling multithreaded calculation prevents the issue, and event logs identify VBE7.DLL with exception code 0xc0000005.
Before you start

Confirm whether the issue occurs with other macro-enabled workbooks and note the installed Office version and build under File > Account > About Excel. Open a blank workbook first so you can change Excel settings without opening the affected file.

Solution 1Recommended

Disable multithreaded calculation in Excel

Use this workaround when the workbook freezes in 64-bit Excel but opens with multithreaded calculation disabled.

1
Open Excel options

Start Excel with a blank workbook, then select File > Options > Advanced.

2
Change calculation settings

Under Formulas, clear Enable multi-threaded calculation, then select OK.

3
Test the workbook

Select File > Open and open the affected macro-enabled workbook to check whether Excel responds normally.

Disable multithreaded calculation in Excel
Workaround limitations: Disabling multithreaded calculation can slow calculation in large workbooks. This workaround does not establish the cause of the VBE7.DLL error.
Free Microsoft Office alternative

Work with Excel files in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface for working with Excel files. It can help you migrate everyday spreadsheet work, but it does not fix a Microsoft Excel crash, and VBA macro support varies by edition and environment.

Open and edit compatible Excel workbooks, including XLSX filesWork with spreadsheet formulas and data in a familiar interfaceUse a free, lightweight Office alternative for everyday filesMove between WPS and Microsoft Office formats for compatible content
microsoft office alternative - wps office

Frequently Asked Questions

Why does disabling multithreaded calculation help?

It changes how Excel calculates workbook formulas and may avoid the conditions that trigger the issue. It does not prove whether VBA, workbook content, or an Office compatibility issue is responsible.

Where can I turn off multithreaded calculation?

Open a blank workbook, select File > Options > Advanced, and clear Enable multi-threaded calculation under Formulas.

Does VBE7.DLL error 0xc0000005 identify the faulty macro?

No. The event identifies the faulting module and exception code, but further testing of the workbook, VBA code, and Office build is needed to isolate the cause.

What should I check in VBA when moving from 32-bit to 64-bit Office?

If the workbook opens, press Alt+F11 and review external API declarations and pointer-related variables. Check that declarations use PtrSafe and LongPtr where appropriate for 64-bit Office.

Can WPS Office run the workbook's macros?

VBA macro support varies by WPS edition and environment, so test the specific workbook before relying on its macros. WPS Office does not repair the Excel VBE7.DLL error.