Updating Chart = Out-Of-RAM

  • Thread starter Thread starter Tom Glitzner
  • Start date Start date
T

Tom Glitzner

I have a 10x10 table which lays to the table as 10 lines
of 10 points.

I am using VBA to generate values in the table. Each pass
is reflected in the Chart.
After 204 passes, the Plot area starts to flash 'Pink' and
the table no longer gets updated (program stalls/freezes?)
Pressing [ESC] or [BREAK] 'stops' the program, the plot
area shows the latest values.

Exiting Excel and re-opening the workbook then running the
program causes the above problem immediatly, the table is
not updated at all.

Running "Resource Meter" reveals "64% System, 64% User,
75% GDI". Starting R.M. before running the program reveals
that System and User both slowly drop from 80% to 64%.

The ONLY way to recover the 'lost' RAM is to re-boot.

Is this just a problem with XL97? Would adding more RAM
(64M now) allow a longer run?
['old' machine: PII 266Mhz 64 of 384MB Win 95]
 
Searching support.microsoft.com for 'chart "out of memory"' (w/o the
single quotes) yields quite a few articles. Check if one or more apply
to you.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top