| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
excel 2007, setting .maximumscale is very slow
Can you break the charting into a Template so it never has to get assigned? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| slow to open Excel 2007 and Word 2007 (MIS stumped) | Excel Discussion (Misc queries) | |||
| My excel 2007 is so slow | Excel Discussion (Misc queries) | |||
| Excel 2007 slow | Excel Programming | |||
| VERY SLOW EXCEL 2007 | Excel Programming | |||
| changing minumumScale and maximumScale of an axis | Charts and Charting in Excel | |||
Linear Mode
