Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Memory Leak When Copying Charts

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



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Memory Leak When Copying Charts

Perhaps turn off font scaling. This was the source of the problem in
earlier versions of excel.

--
Regards,
Tom Ogilvy

"Claus Zimmermann" wrote in message
...
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





  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 340
Default Memory Leak When Copying Charts

Claus, try changing your printer to a Brothers Laser, even if you do not
have one installed. Some print drivers cause memory problems, especially HP
print drivers.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Claus Zimmermann" wrote in message
...
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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Charts & Memory Leak?? Denis[_4_] Excel Worksheet Functions 0 April 20th 11 04:32 PM
XL 2007 - Out of Memory - memory leak/bug? PCLIVE Excel Discussion (Misc queries) 0 March 23rd 09 03:31 PM
Memory Leak MD Excel Programming 1 May 28th 04 05:14 PM
Memory Leak GSS[_2_] Excel Programming 1 December 22nd 03 09:21 PM
Memory Leak using ADO 2.6 Jason[_17_] Excel Programming 2 August 26th 03 02:42 PM


All times are GMT +1. The time now is 03:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"