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

[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.
"Dave Peterson" <[email protected]> ???????/???????? ? ????????
?????????: news:[email protected]...
> 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

[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.
"Jim" <[email protected]> ???????/???????? ? ???????? ?????????:
news:[email protected]...
> 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, but I need the formulas to work sometimes.
"Pete_UK" <[email protected]> ???????/???????? ? ???????? ?????????:
news:[email protected]...
> 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
>

[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!
"Pete_UK" <[email protected]> ???????/???????? ? ???????? ?????????:
news:[email protected]...
> 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
>

[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" <[email protected]> сообщил/сообщила в новостях следующее:
news:[email protected]...
> 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" <[email protected]> ???????/???????? ? ???????? ?????????:
> news:[email protected]...
> > 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]

I changed Calculation to manual. This does not speed up autofiltering
noticeably.
"Pete_UK" <[email protected]> ???????/???????? ? ???????? ?????????:
news:[email protected]...
> 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
>

[Dmitry Kopnichev]

Pressing the escape key does not have an effect on my Excel autofiltering.
"Dave Peterson" <[email protected]> ???????/???????? ? ????????
?????????: news:[email protected]...
> 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'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" <[email protected]> ???????/???????? ? ????????
> ?????????: news:[email protected]...
> > 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

[Dmitry Kopnichev]

My Excel does not respond to any command until a completion of the
autofiltering.
"Dave Peterson" <[email protected]> ???????/???????? ? ????????
?????????: news:[email protected]...
> 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" <[email protected]> ???????/???????? ? ????????
> > ?????????: news:[email protected]...
> > > 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]

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" <[email protected]> ???????/???????? ? ????????
> ?????????: news:[email protected]...
> > 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" <[email protected]> ???????/???????? ? ????????
> > > ?????????: news:[email protected]...
> > > > 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