software

Hello
How to speed up Autofiltering? Excel 2003 sp2 hangs up for 10 minutes after
I choose a record in the Autofilter.
Can you turn calculation to manual?

Or try to interrupt it by pressing the escape key?

Dmitry Kopnichev wrote:
gt;
gt; Hello
gt; How to speed up Autofiltering? Excel 2003 sp2 hangs up for 10 minutes after
gt; I choose a record in the Autofilter.

--

Dave Peterson

Thanks for your reply.
Turning calculation to manual does not speed up my filtering.
A pressing the escape key does not terminate my filtering.
quot;Dave Petersonquot; gt; ???????/???????? ? ????????
?????????: ...
gt; Can you turn calculation to manual?
gt;
gt; Or try to interrupt it by pressing the escape key?
gt;
gt;
gt;
gt;
gt; Dmitry Kopnichev wrote:
gt; gt;
gt; gt; Hello
gt; gt; How to speed up Autofiltering? Excel 2003 sp2 hangs up for 10 minutes
after
gt; gt; I choose a record in the Autofilter.
gt;
gt; --
gt;
gt; Dave Peterson
Is this a large file with a lot of formulae? If so, you can fix the
values of the formulae so that Excel does not have to recalculate them
each time you select a different filter option.

Hope this helps.

PeteI too have a workbook with a long list (about 13,000 lines of data) and
lots of formulae.
My workbook also has several tabs.
I have noticed the delay with the autofilter selection.
I think the problem may be with re-display more than calculation.
I say this because after making an autofilter selection, I can avoid
the wait by
clicking another tab and immediately coming back to my autofilter
sheet.
The data redisplays pronto.
Has anyone else noticed this?Thanks for your reply.
My workbook has about 13,000 lines of data too and some formulas.
I will try to click another tab and immediately come back to my autofilter
sheet.
quot;Jimquot; gt; ???????/???????? ? ???????? ?????????: oups.com...
gt; I too have a workbook with a long list (about 13,000 lines of data) and
gt; lots of formulae.
gt; My workbook also has several tabs.
gt; I have noticed the delay with the autofilter selection.
gt; I think the problem may be with re-display more than calculation.
gt; I say this because after making an autofilter selection, I can avoid
gt; the wait by
gt; clicking another tab and immediately coming back to my autofilter
gt; sheet.
gt; The data redisplays pronto.
gt; Has anyone else noticed this?
gt;
Thanks, but I need the formulas to work sometimes.
quot;Pete_UKquot; gt; ???????/???????? ? ???????? ?????????: ups.com...
gt; Is this a large file with a lot of formulae? If so, you can fix the
gt; values of the formulae so that Excel does not have to recalculate them
gt; each time you select a different filter option.
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;
Yes, It's a large file.
Why does Excel copies a cell so long from these files? The sandglass appears
for half a minute after I click Copy!
quot;Pete_UKquot; gt; ???????/???????? ? ???????? ?????????: ups.com...
gt; Is this a large file with a lot of formulae? If so, you can fix the
gt; values of the formulae so that Excel does not have to recalculate them
gt; each time you select a different filter option.
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;
Hello
I cannot click another tab and immediately come back to my autofilter sheet,
because Excel becomes busy, does not answer.
quot;Dmitry Kopnichevquot; gt; сообщил/сообщила в новостях следующее:
...
gt; Thanks for your reply.
gt; My workbook has about 13,000 lines of data too and some formulas.
gt; I will try to click another tab and immediately come back to my autofilter
gt; sheet.
gt; quot;Jimquot; gt; ???????/???????? ? ???????? ?????????:
gt; oups.com...
gt; gt; I too have a workbook with a long list (about 13,000 lines of data) and
gt; gt; lots of formulae.
gt; gt; My workbook also has several tabs.
gt; gt; I have noticed the delay with the autofilter selection.
gt; gt; I think the problem may be with re-display more than calculation.
gt; gt; I say this because after making an autofilter selection, I can avoid
gt; gt; the wait by
gt; gt; clicking another tab and immediately coming back to my autofilter
gt; gt; sheet.
gt; gt; The data redisplays pronto.
gt; gt; Has anyone else noticed this?
gt; gt;
gt;
gt;
I changed Calculation to manual. This does not speed up autofiltering
noticeably.
quot;Pete_UKquot; gt; ???????/???????? ? ???????? ?????????: ups.com...
gt; Is this a large file with a lot of formulae? If so, you can fix the
gt; values of the formulae so that Excel does not have to recalculate them
gt; each time you select a different filter option.
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;