grouping rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

greg - 25 Jan 2007 16:28 GMT

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

Reply to this Message

Dave Peterson - 25 Jan 2007 17:03 GMT

=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.

> Hello,
> In Excel 2002 if you had lots of groups of rows in a sheet.
[quoted text clipped - 10 lines]
>
> thanks

Signature

Dave Peterson

Reply to this Message

greg - 25 Jan 2007 17:21 GMT

yes,
turning off calc does make it faster.
thanks

> =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
[quoted text clipped - 23 lines]
> >
> > thanks

Reply to this Message

Rate this thread: