Troubleshooting “Available memory is low” when opening multiple workbooks.

The “Available memory is low” warning appears when Excel determines that system-wide RAM or its own internal memory workspace cannot safely accommodate another file. Unlike errors triggered by a single calculation within an active sheet, this message indicates resource starvation caused by cumulative memory load, concurrent workbook processing, or orphaned background instances of Excel remaining active in Windows.

Quick Answer

Open Windows Task Manager (Ctrl + Shift + Esc), check the Details tab, and terminate any hidden EXCEL.EXE background processes. Next, avoid opening multiple massive files inside the same Excel window; launch separate instances or convert supporting workbooks to Manual Calculation mode before opening them.

---

Step 1: Terminate Zombie Excel Processes

Often, Excel fails to shut down cleanly when closed via automation scripts, add-in calls, or heavy crashes. These invisible processes stay loaded in memory, locking up system resources.

1. Press Ctrl + Shift + Esc to open Task Manager.
2. Go to the Details tab and sort by Name.
3. Look for multiple entries named EXCEL.EXE.
4. If you have only one visible workbook open but see three or four EXCEL.EXE processes, select each inactive background entry and click End Process Tree.
5. Reopen your files.

If background processes continually fail to release system resources after automated tasks or macro runs, see Managing “High CPU Usage” by background Excel processes.

---

Step 2: Open Workbooks in Separate Instances

By default, modern versions of Excel open every workbook in a single shared process (EXCEL.EXE). When you open three 150 MB workbooks, they compete for the same virtual memory heap and thread pool.

To isolate heavy workbooks into their own dedicated memory allocations:

1. Open your first workbook normally.
2. Hold down the Alt key on your keyboard.
3. Right-click the Excel icon on your Windows Taskbar and click Excel (while continuing to hold Alt).
4. Keep holding Alt until Excel displays the prompt: “Do you want to start a new instance of Excel?”
5. Click Yes.
6. Open your second workbook inside this completely separate application window.

Each instance now operates with its own protected memory space. A calculation freeze or memory limit reached in one workbook will not crash or starve the other.

---

Step 3: Prevent Chain-Reaction Recalculations

When you open an external workbook that contains formulas linking to other files, Excel automatically attempts to update values and re-evaluate dependent ranges. Opening several linked workbooks simultaneously triggers a calculation cascade that consumes all available memory.

1. Open a blank Excel workbook first.
2. Set calculation to manual: Formulas > Calculation Options > Manual.
3. Now open your target workbooks one by one via File > Open.
4. Excel will respect the Manual mode initiated by the first blank file and suppress simultaneous background calculations.

If cross-sheet calculations trigger infinite loops across linked workbooks during startup, consult Fixing “Calculating (8 Threads): 0%”—The infinite calculation loop.

---

Step 4: Clear the Windows Clipboard and DDE Buffers

Copying massive blocks of data from one workbook to paste into another places enormous serialized data sets into the Windows system clipboard, occupying both physical RAM and virtual swap files.

1. Open the Clipboard task pane by clicking the small launcher arrow in the bottom corner of Home > Clipboard.
2. Click Clear All to drop cached memory objects.
3. If Excel freezes during inter-workbook copying, disable Dynamic Data Exchange (DDE):
   • Go to File > Options > Advanced.
   • Scroll down to the General section.
   • Ensure Ignore other applications that use Dynamic Data Exchange (DDE) is managed appropriately for your environment.

---

Step 5: Adjust Windows Virtual Memory (Paging File)

If your computer has 8 GB to 16 GB of physical RAM and you routinely open multiple data-intensive reports, Windows may run out of commit charge if the paging file is restricted or set to a drive with low free disk space.

1. Press Win + R, type sysdm.cpl, and hit Enter.
2. In the System Properties window, select the Advanced tab.
3. Under the Performance header, click Settings…, then switch to the Advanced tab in the new dialog.
4. Under Virtual memory, click Change….
5. Check Automatically manage paging file size for all drives, or ensure your system drive has at least 1.5 times your physical RAM allocated as a custom page file size.
6. Click OK and restart your computer.

For detailed system-level virtual memory allocation practices, refer to Handling “Virtual Memory” settings to improve Excel stability.

---

Next Steps for Single-File Overload

If the “Available memory is low” warning appears while opening just two standard-sized files, one of the files likely contains damaged internal XML structures, corrupted Pivot caches, or millions of invisible rows. Isolate which workbook is triggering the warning, then apply the structural cleanup steps detailed in Fixing “There isn’t enough memory to complete this action” in large datasets.