VBA & Macro Problems

Fix Excel 2016 VBA Out of Memory Error on a Blank Worksheet

Elise WilliamsElise Williams Nov 22, 2026 869 views

Question details

The user needs to open the Visual Basic Editor in Excel 2016 without an out-of-memory error.

Fix the Excel 2016 VBA Out of Memory Error on a Blank Worksheet
Product
Microsoft Excel 2016 and Access
Device & OS
Windows
Scenario
Opening the Visual Basic Editor from a blank Excel worksheet; the editor also fails in Access.
Observed behavior
Excel reports an out-of-memory error despite available Windows RAM, and the Visual Basic Editor fails in Access as well.
Before you start

Close open Office applications and note whether the error occurs in both Excel and Access. In Excel, check File > Account > About Excel for the Office version and whether it is 32-bit or 64-bit.

Solution 1Recommended

Test Excel in Safe Mode and check add-ins

Use Safe Mode to check whether an add-in or startup configuration contributes to the error.

1
Start Excel in Safe Mode

Press Windows+R, enter excel /safe, and select OK. Open a blank workbook and press Alt+F11 to test the Visual Basic Editor.

2
Review COM add-ins

If the editor opens in Safe Mode, restart Excel normally and go to File > Options > Add-ins. Under Manage, select COM Add-ins and choose Go.

3
Disable and retest

Clear the add-in checkboxes, select OK, and restart Excel. Press Alt+F11 again; if the editor opens, re-enable add-ins one at a time and retest to identify the cause.

Test Excel in Safe Mode and check add-ins
If Safe Mode does not help: Because the editor also fails in Access, an Office installation or shared VBA component may be involved. Continue with Office repair.
Free Microsoft Office alternative

Work with spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format support, making it easier to move everyday spreadsheet work. It does not repair Microsoft's VBA editor.

Open and edit spreadsheets through a familiar interfaceSupports Microsoft Excel formats including XLSX and XLSMContinue everyday spreadsheet work while troubleshooting OfficeMove between common Office document formats
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel report an out-of-memory error when Windows has free RAM?

Available RAM does not rule out an Office configuration, add-in, or VBA component problem. Since Access is also affected, test Excel with Windows+R > excel /safe and consider repairing Office.

How do I open the Visual Basic Editor in Excel?

Open a workbook in Excel and press Alt+F11. You can use the same shortcut after starting Excel in Safe Mode to check whether the editor opens.

How do I find out whether Excel is 32-bit or 64-bit?

In Excel, go to File > Account > About Excel. The About window displays the Office version and architecture.

Can WPS Office fix the Microsoft VBA editor?

No. WPS Office is an alternative for everyday spreadsheet work, but it does not repair Microsoft Office or its Visual Basic Editor. Test any macro-dependent workbook for compatibility before relying on it in another application.