Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Autofilter freezes in Excel 2002

Autofilter freezes in Excel 2002

Autofilter freezes in Excel 2002

My computer was upgraded to Windows XP today via my network login. This included an Excel upgrade to version 2002.

I then have a file with an autofilter applied.
When I work in this suddenly after a while the autofilter just "freezes", i.e. the filter buttons does not react at all.
I can remove the filter, but the filtered rows stays hidden so I have to unhide all rows, reapply the filter and then after a while I can do it all again.

Have anyone else experienced this?

Replies continue below

Recommended for you

RE: Autofilter freezes in Excel 2002

I have been checking around but found no clear solution for you. It may have to do with worksheet protection, array formulas inside the filtered list, or a large number of formulas in the list.
One thing to try is to turn automatic recalculation off and see if you still have the problem.
Array formulas can often be avoided if you can use sumif and countif formulas.

Hope this helps,



Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close