software

Using 2003

In large files (20,000 records on various sheets) is there an efficient way
or procedure to speed up the use of selecting choices with the AutoFilter
dropdown box(es)?

I have:
reset the last cell (on each sheet)
re-booted
released the filter before choicing the next option
and a few other stabs in the dark.

If anyone has some ideas that have worked plese let me know.
I wish that XL had a utility to quot;scrubquot; the .xls files for efficiency like
Access has.

Thanks Dennis

Turning calculation to manual can speed up autofiltering.

I like to just interupt the calculation by hitting a key (usually the escape
key). The filter gets displayed nicely and I can usually wait for the
calculation.

Dennis wrote:
gt;
gt; Using 2003
gt;
gt; In large files (20,000 records on various sheets) is there an efficient way
gt; or procedure to speed up the use of selecting choices with the AutoFilter
gt; dropdown box(es)?
gt;
gt; I have:
gt; reset the last cell (on each sheet)
gt; re-booted
gt; released the filter before choicing the next option
gt; and a few other stabs in the dark.
gt;
gt; If anyone has some ideas that have worked plese let me know.
gt; I wish that XL had a utility to quot;scrubquot; the .xls files for efficiency like
gt; Access has.
gt;
gt; Thanks Dennis

--

Dave Peterson

Thanks Dave,

You know the old quot;assumptionquot; gag. I assumed that auto-filtering was in
and up itself a calculation. BTW, with the calc on, I have tried to stop the
process by hitting Esc numerous times to no avail.

I now must experiment a new!

quot;Dave Petersonquot; wrote:

gt; Turning calculation to manual can speed up autofiltering.
gt;
gt; I like to just interupt the calculation by hitting a key (usually the escape
gt; key). The filter gets displayed nicely and I can usually wait for the
gt; calculation.
gt;
gt; Dennis wrote:
gt; gt;
gt; gt; Using 2003
gt; gt;
gt; gt; In large files (20,000 records on various sheets) is there an efficient way
gt; gt; or procedure to speed up the use of selecting choices with the AutoFilter
gt; gt; dropdown box(es)?
gt; gt;
gt; gt; I have:
gt; gt; reset the last cell (on each sheet)
gt; gt; re-booted
gt; gt; released the filter before choicing the next option
gt; gt; and a few other stabs in the dark.
gt; gt;
gt; gt; If anyone has some ideas that have worked plese let me know.
gt; gt; I wish that XL had a utility to quot;scrubquot; the .xls files for efficiency like
gt; gt; Access has.
gt; gt;
gt; gt; Thanks Dennis
gt;
gt; --
gt;
gt; Dave Peterson
gt;