Fix Excel Memory or Disk Space Errors When Opening New Workbooks
Question details
The user needs to open new Excel workbooks without an insufficient memory or disk space error.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating or opening a new workbook when the computer appears to have sufficient memory and storage.
- Observed behavior
- Excel displays an insufficient memory or disk space message, and opening a template may also cause corruption.
Check that the system drive has free space and that you can create a file in your temporary folder. The troubleshooting steps below use Windows; menu names can vary by Office version.
Test Excel in Safe Mode and Check Startup Files
Use Safe Mode to check whether add-ins or startup files are contributing to the error.
Press Windows+R, enter excel /safe, and select OK. In Excel, select File > New > Blank workbook to test a new workbook.
If the blank workbook opens in Safe Mode, go to File > Options > Add-ins. Under Manage, select COM Add-ins and click Go; clear the selected add-ins, then restart Excel normally. Repeat with Excel Add-ins if needed.
Close Excel. Press Windows+R, enter %appdata%\Microsoft\Excel\XLSTART, and move any files in that folder temporarily to another folder. Restart Excel and test File > New > Blank workbook.
In Excel, open File > Options > Advanced and find the General section. Check the folder listed under At startup, open all files in; temporarily remove or relocate its startup files and test again.

Repair Microsoft Office
Repair Office installation files if Safe Mode and startup checks do not resolve the error.
Test a New Windows Profile or Reinstall Office
Use a new profile to check for user-specific settings or permission problems, then consider reinstalling Office if repair has failed.
Create New Workbooks with WPS Spreadsheets
WPS Office is a free, lightweight, easy-to-use alternative with a familiar interface and Microsoft Office format support, making it straightforward to move spreadsheet work to another app. It does not repair Microsoft Excel itself.

Frequently Asked Questions
Why does Excel report insufficient memory when the computer has plenty available?
The message can also be caused by add-ins, startup files, permissions, damaged Office files, or user-specific settings. Start Excel with Windows+R > excel /safe and test a blank workbook.
Where can I find Excel's startup files?
Press Windows+R and enter %appdata%\Microsoft\Excel\XLSTART. Also check File > Options > Advanced > General for a folder listed under At startup, open all files in.
What should I do if Office repair does not fix the error?
Test Excel under a new Windows user account and check access to the %TEMP% folder. If the problem persists, consider reinstalling Office after saving copies of custom templates and macros.
Will disabling add-ins delete them?
Clearing an add-in in File > Options > Add-ins > Manage > Go disables it without necessarily uninstalling it. You can return to the same dialog to enable it again.




