How to speed up Autofiltering?

[Dmitry Kopnichev]

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

 

[Dave Peterson]

Can you turn calculation to manual?

Or try to interrupt it by pressing the escape key?

 

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

 

[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

 

[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?

 

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

 

[Dmitry Kopnichev]

Thanks, but I need the formulas to work sometimes.

 

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

 

[Dmitry Kopnichev]

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

 

[Dmitry Kopnichev]

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

 

[Dmitry Kopnichev]

Pressing the escape key does not have an effect on my Excel autofiltering.

 

[Dave Peterson]

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

 

[Dmitry Kopnichev]

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

 

[Dave Peterson]

I don't have any other suggestions.

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