Thanks, but is there any way to turn off auto calculation when opening and
closing row groups only rather than going to manual calculation even if it
must be done via VB ? This would be like turning calculation mode off for
tables?

Thanks
Ken




"Jim Rech" wrote:

This article explains what you're run into:

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

--
Jim
"KMH" wrote in message
...
| My company has upgraded to Excel 2003 (yes we are behind the times) and
ever
| since, the primary Excel template that I use and I am a developer of has
| gotten much much slower. Not exactly the upgrade I was looking for. It
now
| takes about 5-10 seconds on a high end computer to just open up row
groups.
| I would like suggestions on how to change my model to make the model
faster.
| Thanks.
|
| Background:
| The spreadsheet template is primarily an options analysis tool where 1
| option is in a single column on 1 worksheet which is 2100 rows long
(broken
| into 5 row group levels) and has at least 40 example columns and that
number
| could grow to fill out all 256 columns possible in some rare cases but
| probably at least 75-80 columns normally. There are 4 different summary
| output worksheets that reference the primary sheet pulling the appropriate
| information off via Offset functions so that the output summary reports
can
| be quickly and easily customized. I have rewritten code on the primary
sheet
| to move away from as many volatile functions as possible but there are
some
| that are just not convenient to get rid of -- I have about 20 cells per
| column that have Offset functions contained within it. I use these 20
cells
| to do relative comparisons between columns where the "base column" that I
| compare relatively needs to vary so the Offset is the quickest way to do
that
| - I just have to tell it the column to look in. I could write VB code to
get
| rid of these offset functions, but the on the fly comparison functionality
is
| needed and VB code will just make that part of the model slower. As
stated
| earlier, the 4 different summary sheets are almost entirely offset
functions
| that work off a column ID as well. I don't have to have the calculation
| modes turned on for these other worksheets when they are not active so is
it
| possible to turn this off or is it off already? Thanks for any help.
|
|