VBA & Macro Problems

Fix a Microsoft 365 Excel Macro Workbook That Hangs or Reports Low Memory

Emma BrownEmma Brown Nov 22, 2026 868 views

Question details

Identify why a macro-enabled workbook that opens in Excel 2007 hangs, closes, or reports insufficient memory in Microsoft 365 Excel.

Fix a Microsoft 365 Excel Macro Workbook That Hangs or Reports Low Memory
Product
Microsoft 365 Excel
Device & OS
Windows, 64-bit
Scenario
Opening an existing macro-enabled workbook in Microsoft 365 Excel.
Observed behavior
The workbook hangs, closes Excel, or reports insufficient memory despite available RAM, although it opens in Excel 2007.
Before you start

Confirm that you can reproduce the issue with the affected workbook and note any error message. Test one change at a time, and enable macros only if you trust the workbook and its source.

Solution 1Recommended

Test Excel Safe Mode and disable COM add-ins

Use Safe Mode to check whether an add-in or startup customization contributes to the failure.

1
Start Excel in Safe Mode

Hold Ctrl while selecting the Excel application icon, then confirm that you want to start Excel in Safe Mode.

2
Test the workbook

In Excel, select File > Open and open the affected workbook. Note whether it opens without hanging or reporting a memory error.

3
Check COM add-ins

Close Excel and reopen it normally. Go to File > Options > Add-ins, select COM Add-ins in the Manage list, and select Go.

4
Disable and retest

Clear one add-in's checkbox, select OK, and reopen the workbook. Repeat one add-in at a time to identify a possible conflict.

Test Excel Safe Mode and disable COM add-ins
Interpreting the test: If the workbook opens in Safe Mode, an add-in or another startup difference may be involved; Safe Mode does not by itself identify the cause.
Free Microsoft Office alternative

Work with Excel Workbooks in WPS Spreadsheets

WPS Office is a free, lightweight Office alternative with a familiar interface for working with spreadsheet files. It supports common Excel formats, making it easier to move everyday work between applications. It does not repair Microsoft 365 Excel, and VBA support and macro behavior can vary by WPS edition and environment.

Open and edit spreadsheets with a familiar interfaceCompatible with common Microsoft Excel formats, including XLSX and XLSMUse a free, lightweight office suite for everyday spreadsheet workTest workbook content in an alternative application while troubleshooting Excel
microsoft office alternative - wps office

Frequently Asked Questions

Why does the workbook report low memory when RAM is available?

The message can have causes other than a shortage of physical RAM. Test Excel in Safe Mode, check COM add-ins under File > Options > Add-ins, and try a different default printer to narrow down possible conflicts.

How do I start Excel in Safe Mode?

Hold Ctrl while selecting the Excel application icon and confirm the Safe Mode prompt. Then use File > Open to test the affected workbook.

What should I do if the workbook opens in Safe Mode?

Restart Excel normally and go to File > Options > Add-ins. Choose COM Add-ins in the Manage list, select Go, and disable add-ins one at a time, testing the workbook after each change.

Why test a different Windows user profile?

A separate profile helps determine whether the problem is associated with the original user's settings. Add a test account under Settings > Accounts > Other users, sign in, and open an accessible copy of the workbook.

Will the workbook's VBA macros work in WPS Spreadsheets?

WPS can open common Excel formats, including XLSM, but VBA support and macro behavior vary by edition and environment. Test the workbook's macros in the specific WPS setup rather than assuming they will behave exactly as they do in Excel.