Hi All

I have a VBA program in excel that loads the data values of a pivot table from a list. The info is then copied to another worksheet. A chart is then generated from the data. The pivot table is then refreshed with the next value from the list. and the process is repeated.

I need to plot some 1500 graphs from the data.

I am experiencing an message saying out of memory after a certian number of graphs have been plotted (dependant upon the detail on the graph)

the most graphs I have produced is
112 with no details ie titles legends etc

for a graph with full titles legends and axis labels I get around 40.

I have tried plotting a certain number then copying the worksheet to another workbook saving and closing then carrying on in the original workbook for new data but i still get the error message after 40 graphs have been produced regardles of some being saved in another workbook

Has anyone experienced this problem in the past.

Many Thanks
Jamie

Jamie:

I guess many people havehad this problem: the archives will have examples still, no doubt.
Some of the wiser words on (a) memory leakage and (b) deleting finished objects (set [object] = Nothing) have come from Leo Scott. Could be a search through his copious and useful contributions would give you some pointers.

Alf

When Excel accesses a chart it creates a new thread to mschart, when another chart is accessed it creates another thread, when you go back to the first chart it creates another thread. This goes on and on until the out of memory meesage. There's no real way around this that I know except to close and reopen Excel everynow and again to reset the mschart threads.
Once a spreadsheet has had the Out of memory message your better off replicating it as it's all downhill from there!

Ben