Fix Excel 2016 VBA Out of Memory Error on a Blank Worksheet
Question details
The user needs to open the Visual Basic Editor in Excel 2016 without an out-of-memory error.

- 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.
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.
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.
Press Windows+R, enter excel /safe, and select OK. Open a blank workbook and press Alt+F11 to test the Visual Basic Editor.
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.
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.

Repair the Office installation
Repair Office when the Visual Basic Editor fails across applications or Safe Mode does not resolve the error.
Escalate a persistent VBA editor error
Seek technical support if Safe Mode and Office repair do not resolve the problem.
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.

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.




