Excel Performance Problems

Fix Excel Not Enough Memory Error for a Specific Workbook

Camila MilosovichCamila Milosovich Nov 4, 2026 868 views

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.

How to Fix Excel Not Enough Memory Error for a Specific Workbook
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.
Before you start

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.

Solution 1Recommended

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.

1
Create a new workbook

Open your newer version of Excel (e.g., Microsoft 365) and create a completely blank workbook.

2
Open the problematic file in a working environment

Upload and open the original workbook in Excel for the web, where it is known to function without the memory error.

3
Copy data in stages

Copy the data from the original file sheet by sheet or section by section, rather than moving everything at once.

4
Paste and test

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.

Identify the culprit: If the error occurs immediately after copying a specific section, you have successfully isolated the damaged or incompatible data.
Free Microsoft Office alternative

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. 1. Install WPS Office: Download the free installation package from the official WPS website and install it on your PC.
  2. 2. Open the legacy file: Launch WPS Spreadsheet, click on 'Open', and select the workbook that is triggering memory errors in Microsoft Excel.
  3. 3. Edit without memory constraints: Edit, format, and save your data seamlessly, bypassing Microsoft 365's specific workbook compatibility errors.
Fully compatible with Microsoft Excel file formats, including .xls, .xlsx, and .xlsm.Lightweight architecture consumes significantly less system memory during heavy data processing.Familiar ribbon interface ensures a smooth transition with zero learning curve.Free to download and use for all your essential spreadsheet tasks.
microsoft office alternative - wps office

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.