Fix a Microsoft 365 Excel Macro Workbook That Hangs or Reports Low Memory
Question details
Identify why a macro-enabled workbook that opens in Excel 2007 hangs, closes, or reports insufficient memory in Microsoft 365 Excel.

- 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.
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.
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.
Hold Ctrl while selecting the Excel application icon, then confirm that you want to start Excel in Safe Mode.
In Excel, select File > Open and open the affected workbook. Note whether it opens without hanging or reporting a memory error.
Close Excel and reopen it normally. Go to File > Options > Add-ins, select COM Add-ins in the Manage list, and select Go.
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 a different default printer
Use this check to determine whether the current printer or its driver is affecting Excel.
Check for Windows startup and profile conflicts
Use a clean boot and a different Windows profile to isolate third-party software or profile-specific settings.
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.

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.




