excel 2007, setting .maximumscale is very slow

[bmurphy]

In excel 2007 I am finding that sometimes the following statement
executes verrrrry slowly

ActiveChart.Axes(xlCategory).MinimumScale = xmn

Does anyone know any tricks to speed this up in excel 2007?

Is it true that a Service Pack 1 Beta is out and about?
Can anyone say when it is supposed to be ready for the masses?

Thanks,

Brian Murphy

 

[gimme_this_gimme_that]

Can you break the charting into a Template so it never has to get
assigned?

 

[Jon Peltier]

One issue with Excel 2007 charts with a lot of points is that it isn't "too
slow" until you set non-default values for axis scales. Then it can be
"excruciatingly" slow (terms in quotes are my own subjective descriptions).

A hotfix is available that addresses this problem, which in my experience
changes the behavior to "uncomfortably" slow. (In contrast, Excel 2003 is
"fast".)

The hotfix is described here; you have to call MS Support, and they'll email
you a link:

http://support.microsoft.com/kb/938538

- Jon

 

[Jon Peltier]

Then the chart in the template will also be slow. The problem seems to be
having non-auto scale settings. See my other post for a remedy (hotfix).

- Jon

 

[bmurphy]

Thanks, Jon.

It's too bad you have to jump through hoops to get software updates to
buggy products.

The sooner the alleged Service Pack comes out, the better.

Brian