Archive of Mr Excel Message Board

i used to and continue to have this problem all the time. i've asked around and haven't gotten any definitive answers how to solve this problem.

i think the 'out of memory' problem is specific to each machine (i.e., depends on how much memory your machine has installed).

the 1st thing you should do is close ALL other applications that are running in the background when you work on these charts in excel (e.g., Lotus Notes, e-mail, Internet browsers, other Win applications, etc.). they all use up memory and some are notorious memory hogs.

next, i've heard that if you re-boot or start working on these charts right after you boot up the machine, this will help because all of your computer actions eat up space in the memory cache (my terminology could be wrong, but the general premise is ok).

last resort, split up your charts into different files. this stinks, but i've had to break apart files with 50 charts into 5 smaller files with 10 charts each just to play it safe.

if you get any definitive answers off this board, i'd appreciate if you could share with us your findings. thanks.

-han

I did find one way around this that worked temporarily. I can't remember where I read this solution but it worked on workbooks with approx. 50 charts. Create a blank worksheet and name it however you would like. When you go to save the file, make sure that the blank sheet is the active sheet and then save. Never save the workbook when the blank sheet is not the active sheet. This worked for me when I used a smaller number of charts. However, now that I am using 100+ charts, I'm having no luck with that method.

Harley,

Two suggestions...

Read the Microsoft KB article: Q168650
"Not enough memory error adding chart to workbook"
This article applies to XL 97 only.
If you are using Internet Explorer you can enter: "mskb Q168650" in the address bar to go directly to the article.

See Charles Williams' web site...
http://www.decisionmodels.com/memlimitsc.htm
for lots of info on Excel memory problems.

Regards,

Jim Cone
San Jose, CA

================================================