Re: Memory Leak when copying Excel Charts to another worksheet
From: Jon Peltier (DOjonNOTxlmvp_at_SPAMpeltiertechME.com)
Date: Tue, 17 Aug 2004 19:29:52 -0400
That's a lot of charts. Is it possible to show your data with fewer
charts? Perhaps a dynamic chart that you can control with a drop down or
other worksheet control. Or dividing it into multiple workbooks.
Here are a few examples of charting with worksheet controls to specify
In effect, the control is used to easily redefine a dynamic range on the
fly, so it displays the selected subset of the data.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
Claus Zimmermann wrote:
> I have a BAD memory leak when I copy a chart... even a blank chart to
> another worksheet. It eventually causes excel to crash.
> In my example, the sequence to crash excel was as follows:
> - Copy Chart 5000 times (loop) - less times would work too, and you'd
> see the increase in private bytes as you go along
> - Copy method of range class failed
> - Clicked End button on debug message box
> - Closed Excel
> - Message: The picture is too large and will be truncated
> - Excel.exe - Application error. The instruction at "0x300dc756"
> referenced memory at "0x000000008". The memory could not be read.
> I'm using Excel 2000 sp3
> To test memory I'm using perfmon, and am testing private bytes in Excel.
> Any suggestions or a workaround?
> Sample macro available illustrating this on request.