excel 2007, setting .maximumscale is very slow
 

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

excel 2007, setting .maximumscale is very slow
 

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

excel 2007, setting .maximumscale is very slow
 

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


wrote in message
oups.com...
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

excel 2007, setting .maximumscale is very slow
 

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


wrote in message
ups.com...


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

excel 2007, setting .maximumscale is very slow
 

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