MrExcel Publishing
Your One Stop for Excel Tips & Solutions

"not enough memory" error message

Posted by pgs on August 10, 2001 12:06 PM

I'm creating a workbook that will contain 60 or 70 charts (maybe) but about 32 charts into it I am getting "not enough memory" error. At first I had separate worksheet for each chart then I converted each one to a "chart sheet", that didn't help. I moved to a machine with more RAM and that didn't help. I'm thinking that there is an Excel level limit to the amount of memory one workbook can hook into. If so is it modifyable by the user ?

Posted by Russell Hauf on August 10, 2001 2:02 PM

I had the same problem. Are you creating the charts via VBA? What I did to resolve it was to split the charts onto multiple workbooks. When I got to 31 charts I would save and close the current book and add a new workbook and keep going. I would like to hear if there is another solution to this problem.

Posted by Ivan F Moala on August 12, 2001 3:26 AM

If your using excel97 then have a look @



Posted by Tom Urtis on August 13, 2001 9:06 AM

pgs --

It's little consolation, but with this problem you've joined many others who've experienced this same thing. It appears that when Excel runs large macros involving charts or graphics, or when a user simply creates a lot of charts in a worksheet, those applications use up memory in your system that is not replenished until you reboot. Rumor had it that Excel 2000 would address this issue but it still seems a problem.

Tom Urtis