Hi,

I have a spreadsheet that draws a chart with VBA from a largeish
dataset. In Excel 2000 and 2003 the code runs in a fraction of a
second and is perfectly fine. With 2007 on the same machine, however,
the code crawls. It redraws the chart at every step of code (even when
the code has nothing to do with the chart), ignoring ScreenUpdating =
False and Calculation = xlManual. One of my Core 2 processors maxes
out (1GB RAM) and the fan pulses each step too. Eventually it seems as
if Excel just gives up and the system crashes.

Having read around this Group it seems like this was a noted as a
problem earlier in the year. For me it is a complete show-stopper and
makes Excel 2007 essentially useless. Feeling quite ripped off,
actually.

Is there anything we/I can do about this? Any help / suggestions on
what to do next much appreciated.

Cheers

Gromit