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:

Hello
How to speed up Autofiltering? Excel 2003 sp2 hangs up for 10 minutes after
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.
"Dave Peterson" ???????/???????? ? ????????
?????????: ...
Can you turn calculation to manual?

Or try to interrupt it by pressing the escape key?




Dmitry Kopnichev wrote:

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

--

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.

Pete

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?

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.
"Jim" ???????/???????? ? ???????? ?????????:
oups.com...
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?

Thanks, but I need the formulas to work sometimes.
"Pete_UK" ???????/???????? ? ???????? ?????????:
ups.com...
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

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!
"Pete_UK" ???????/???????? ? ???????? ?????????:
ups.com...
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

I changed Calculation to manual. This does not speed up autofiltering
noticeably.
"Pete_UK" ???????/???????? ? ???????? ?????????:
ups.com...
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

Pressing the escape key does not have an effect on my Excel autofiltering.
"Dave Peterson" ???????/???????? ? ????????
?????????: ...
Can you turn calculation to manual?

Or try to interrupt it by pressing the escape key?




Dmitry Kopnichev wrote:

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

--

Dave Peterson

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

Dmitry Kopnichev wrote:

Pressing the escape key does not have an effect on my Excel autofiltering.
"Dave Peterson" ???????/???????? ? ????????
?????????: ...
Can you turn calculation to manual?

Or try to interrupt it by pressing the escape key?




Dmitry Kopnichev wrote:

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

--

Dave Peterson

--

Dave Peterson

My Excel does not respond to any command until a completion of the
autofiltering.
"Dave Peterson" ???????/???????? ? ????????
?????????: ...
I've always had good luck with both those techniques. Sorry that they
didn't
work for you.

Dmitry Kopnichev wrote:

Pressing the escape key does not have an effect on my Excel
autofiltering.
"Dave Peterson" ???????/???????? ? ????????
?????????: ...
Can you turn calculation to manual?

Or try to interrupt it by pressing the escape key?




Dmitry Kopnichev wrote:

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

--

Dave Peterson

--

Dave Peterson

I don't have any other suggestions.

Dmitry Kopnichev wrote:

My Excel does not respond to any command until a completion of the
autofiltering.
"Dave Peterson" ???????/???????? ? ????????
?????????: ...
I've always had good luck with both those techniques. Sorry that they
didn't
work for you.

Dmitry Kopnichev wrote:

Pressing the escape key does not have an effect on my Excel
autofiltering.
"Dave Peterson" ???????/???????? ? ????????
?????????: ...
Can you turn calculation to manual?

Or try to interrupt it by pressing the escape key?




Dmitry Kopnichev wrote:

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

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson