How to speed up Autofiltering?

D

Dmitry Kopnichev

Hello
How to speed up Autofiltering? Excel 2003 sp2 hangs up for 10 minutes after
I choose a record in the Autofilter.
 
D

Dave Peterson

Can you turn calculation to manual?

Or try to interrupt it by pressing the escape key?
 
D

Dmitry Kopnichev

Thanks for your reply.
Turning calculation to manual does not speed up my filtering.
A pressing the escape key does not terminate my filtering.
 
P

Pete_UK

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.

Pete
 
J

Jim

I 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?
 
D

Dmitry Kopnichev

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

Dmitry Kopnichev

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!
 
D

Dmitry Kopnichev

Hello
I cannot click another tab and immediately come back to my autofilter sheet,
because Excel becomes busy, does not answer.
 
D

Dmitry Kopnichev

I changed Calculation to manual. This does not speed up autofiltering
noticeably.
 
D

Dave Peterson

I've always had good luck with both those techniques. Sorry that they didn't
work for you.
 
D

Dmitry Kopnichev

My Excel does not respond to any command until a completion of the
autofiltering.
 
Top