Memory Leak when copying Excel Charts to another worksheet

[Claus Zimmermann]

Hi

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.

Claus

 

[Jon Peltier]

Claus -

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
what's charted:

http://peltiertech.com/Excel/Charts/ChartByControl.html
http://peltiertech.com/Excel/Charts/ChartTypeDropDown.html

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Claus Zimmermann]

Thank you John

I have created a report generator which recursively prints 100s of reports,
so performance is an issue.

I solved the problem by copying the charts as pictures and concomitantly
clearing the clipboard. This worked so well I was bowled over!

Claus

 

[Jon Peltier]

Claus -

Good idea. I often copy charts as pictures before moving them to
PowerPoint or Word, to prevent a slew of issues. Pictures of charts
don't need the data, so that also helps performance.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______