Excel Memory Leaks
Memory Leaks occur when a program (Excel, VBA
) obtains some
memory but fails to hand it back to the memory manager.
Sometimes you can delay the point at which you run out of memory by increasing the size of your Swapfile.
You can easily monitor memory leaks with Windows NT, 2000, XP, 7, 8 and 10 using the Windows Task Manager.
Here is a partial list of things that can cause memory leaks:
Excels UNDO feature does not have a memory leak but will use
up memory that could otherwise be used for formulae.
You can reduce the number of Undo levels by editing the Registry. This will tend to reduce the memory used by UNDO: see Q211922 - XL2000: How to Modify the Number of Undo Levels.
On large spreadsheets you should be careful about editing very large numbers of formulae in a single step: edit in small steps with intermediate saves.