Fix 64-Bit Excel Freezing When Opening a Macro-Enabled Workbook
Question details
Determine why a macro-enabled workbook opens in 32-bit Office but causes 64-bit Excel to stop responding.

- 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.
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.
Disable multithreaded calculation in Excel
Use this workaround when the workbook freezes in 64-bit Excel but opens with multithreaded calculation disabled.
Start Excel with a blank workbook, then select File > Options > Advanced.
Under Formulas, clear Enable multi-threaded calculation, then select OK.
Select File > Open and open the affected macro-enabled workbook to check whether Excel responds normally.

Isolate the workbook and review 64-bit VBA compatibility
Use these checks to determine whether the issue is specific to the workbook, its VBA code, or an Office build.
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.

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.




