Fix Excel Not Enough Memory Error for a Specific Workbook
Question details
The user is encountering an insufficient memory error when attempting to open or work with a specific Excel workbook, despite having a computer with adequate RAM.

- Product
- Microsoft Excel
- Device & OS
- Windows 10 (64-bit)
- Scenario
- Attempting to use a legacy Excel workbook in newer desktop versions like Microsoft 365 or Office 2013+.
- Observed behavior
- Excel displays an insufficient memory error and fails to process the workbook in newer desktop versions, even though the same file works correctly in Excel 2010 and Excel for the web.
Verify that your computer has sufficient available RAM via the Windows Task Manager, and create a backup copy of your problematic workbook to prevent accidental data loss during troubleshooting.
Rebuild the Workbook by Staged Copying
Manually migrating data to a newly created file helps bypass deep-rooted corruption and version compatibility issues.
Since the file functions properly in older versions like Excel 2010 or Excel for the web, the underlying structure of the file may be incompatible with newer Microsoft 365 memory management. Rebuilding it isolates the problematic element.
Open your newer version of Excel (e.g., Microsoft 365) and create a completely blank workbook.
Upload and open the original workbook in Excel for the web, where it is known to function without the memory error.
Copy the data from the original file sheet by sheet or section by section, rather than moving everything at once.
Paste the copied sections into the new desktop workbook. Save the file and perform basic actions after each paste to identify exactly which sheet or component triggers the memory error.
Remove Hidden Objects and Simplify Formulas
Excessive hidden formatting, objects, or heavy volatile formulas can artificially inflate memory requirements in newer Excel versions.
Open Complex Spreadsheets Smoothly with WPS Office
If Microsoft Excel continues to struggle with memory errors on specific legacy files, consider switching to WPS Office. It is a highly compatible, lightweight alternative that efficiently handles complex spreadsheets without the heavy resource constraints often found in newer Microsoft desktop versions.
- 1. Install WPS Office: Download the free installation package from the official WPS website and install it on your PC.
- 2. Open the legacy file: Launch WPS Spreadsheet, click on 'Open', and select the workbook that is triggering memory errors in Microsoft Excel.
- 3. Edit without memory constraints: Edit, format, and save your data seamlessly, bypassing Microsoft 365's specific workbook compatibility errors.

Frequently Asked Questions
Why does Excel say 'not enough memory' when I have 16GB or 32GB of RAM?
Excel's memory limits are often restricted by the application's architecture (especially if you are using a 32-bit version) rather than your system's total physical RAM. Additionally, file corruption, excessive formatting, or endless formula loops can artificially trigger this error regardless of your hardware.
Why does my workbook open fine in Excel for the web but not on the desktop?
Excel for the web processes data on cloud servers and ignores or bypasses many desktop-specific features, such as certain VBA macros, legacy COM add-ins, or broken OLE links, which may be causing memory conflicts in the newer desktop applications.
Will installing the 64-bit version of Microsoft 365 fix the memory error?
If your workbook is exceptionally large, upgrading from the 32-bit to the 64-bit version of Office allows Excel to access more system RAM. However, if the memory error is caused by localized file corruption or an incompatibility specific to the newer Office engine, upgrading to 64-bit might not resolve the issue.
How can I reduce the memory usage of my Excel workbook?
You can optimize your workbook's memory footprint by deleting unused rows and columns, removing unnecessary conditional formatting, converting volatile formulas to static values, and eliminating hidden shapes using the Selection Pane.




