- The computer uses more memory when you open multiple Microsoft Excel files, save Excel files, or make calculations in Excel workbooks.
- You can no longer open as many Excel workbooks in the same instance as you could before you upgraded to Excel.
- When you insert columns in an Excel workbook, you receive an error about available memory.
- When you are working with an Excel worksheet, you receive the following error message:
There isn't enough memory to complete this action.
Try using less data or closing other applications.
To increase memory availability, consider:
- Using a 64-bit version of Microsoft Excel.
- Adding memory to your device
The following options can help improve performance in Excel 2013/2016:
- Excel users who regularly work with large, complex Excel worksheets may benefit from using the 64-bit edition of Office 2013 because 64-bit editions of Windows-based applications can address up to 8 terabytes (TB) of memory. Learn more about 64-bit editions of Office 2013.
- The 2-GB limitation is per windows process instance of Excel. You can run multiple files in one instance. However, if the files are really large and have to be open, consider opening multiple instances for the other files. For information about limits that you may encounter, go to the following website:
- If you are running Windows 7 or Windows 2008, we suggest that you install Platform update for Windows 7 SP1 and Windows Server 2008 R2 SP1.
- Test performance without COM add-ins. COM add-ins can use memory at the expense of the 2-GB limitation. For testing, disable COM add-ins, and then start Excel. If COM add-ins are causing the memory issue, contact your third-party vendor for an updated copy or a 64-bit version of the COM add-ins.
- Disable hardware graphics acceleration. This shuts off animations. To do this, on the File menu, click Options, click Advanced, click Display, and then select Disable hardware graphics acceleration.
- Change your workbook to streamline areas that use memory unnecessarily. For suggested changes, see the following Knowledge Base article: 3070372 How to clean up an Excel 2013 workbook so that it uses less memory
Before moving to a 64-bit version of Office, please review the information at this link:
2779852 How to Troubleshooting Available Resources errors in Excel