grouping rows
 

Hello,
In Excel 2002 if you had lots of groups of rows in a sheet.
When you expanded/shrunk them, it would be done immediately.

Moving to Excel 2003, this process was slowed down. Almost to a crawl.

The thought around my office here, was it was done on purpose.
To show the end user the expansion.

Is there a way to make it run faster?
Like in the 2002 version?
is there a 2003 setting for this?

thanks

grouping rows
 

=subtotal() was enhanced in xl2003. It now provides a way to ignore rows that
are hidden -- not just by data|Filter|autofilter. (the 100 series parms like
=subtotal(10x,...))

But with that enhancement, xl2003 thinks that it should recalculate each time
you hide/unhide rows.

Maybe you could turn calculation to manual (Tools|Calculation tab), then do what
you want.

Remember to recalc or go back to automatic recalc before you trust the results
of any formula.

greg wrote:

Hello,
In Excel 2002 if you had lots of groups of rows in a sheet.
When you expanded/shrunk them, it would be done immediately.

Moving to Excel 2003, this process was slowed down. Almost to a crawl.

The thought around my office here, was it was done on purpose.
To show the end user the expansion.

Is there a way to make it run faster?
Like in the 2002 version?
is there a 2003 setting for this?

thanks

--

Dave Peterson

grouping rows
 

yes,
turning off calc does make it faster.
thanks

"Dave Peterson" wrote in message
...
=subtotal() was enhanced in xl2003. It now provides a way to ignore rows
that
are hidden -- not just by data|Filter|autofilter. (the 100 series parms
like
=subtotal(10x,...))

But with that enhancement, xl2003 thinks that it should recalculate each
time
you hide/unhide rows.

Maybe you could turn calculation to manual (Tools|Calculation tab), then
do what
you want.

Remember to recalc or go back to automatic recalc before you trust the
results
of any formula.

greg wrote:

Hello,
In Excel 2002 if you had lots of groups of rows in a sheet.
When you expanded/shrunk them, it would be done immediately.

Moving to Excel 2003, this process was slowed down. Almost to a crawl.

The thought around my office here, was it was done on purpose.
To show the end user the expansion.

Is there a way to make it run faster?
Like in the 2002 version?
is there a 2003 setting for this?

thanks

--

Dave Peterson