MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Not Enough Memory Error

Posted by Tony Kalwasinski on May 01, 2001 6:55 PM

I have a seven sheet file with data arranged by date(columns) and type of defect(rows).
When I try to create a graph, or other formatting, I get a "not enough memory" error.
I have 64 Mb ram, and lots of free space on my hard drive. Is Excel referring to this memory,
or does it have an "internal" memory that is too full?
How do I correct this problem?

Thank you,

Tony K./ San Marcos, CA.

Posted by Kevin James on May 01, 2001 7:09 PM

Hi Tony,

EXCELlent question. (pun intended)

You are right in fingering RAM as the culprit. No, Excel doesn't have "memory" that it works with.

Try this:
1. Close all pgms except Excel and try it again. If it doesn't work then..
2. Increase your virtual memory. (You'll have to reboot after this.)
3. Delete all *.tmp files on your system and run scandisk and defrag.
4. Reopen your Excel file and try your graph again. If still no go, you'll need to buy more RAM.

Posted by Tom Urtis on May 01, 2001 10:51 PM

Tony --
In non-SR2 versions of Excel 97 and before, creating graphs, charts, and lengthy macros uses up memory in your computer that is not recouped until & unless you restart the computer. I've run into this myself with my 288 mb ram computer. The problem appears to be an Excel issue and not a system issue, and if it's any consolation, you've experienced the same problem that a lot of others also have had.

Posted by Christina on May 03, 2001 11:22 AM

Tom - Is this issue resolved in more recent versions of Excel?