Why do my autofilters 'freeze'?

[Guest]

Hi,

I have an issue where my Autofilters regularly freeze - ie, once filtered,
the little blue arrow can not be clicked on. However, I can still do other
work in my workbook or go to another worksheet and autofilter works fine.

The only way to 'unfreeze' the filter is to remove the autofilter, unhide
the filtered cells (cannot use show all), and then go to another sheet, do
some work and come back and re-apply the autofilter. I cannot reapply it
straight away or it just stays frozen! I have to have the action in between.

Any ideas? or is this just weird!

Many thanks.

 

[Guest]

How large is your data?

 

[Guest]

It varies. Some workbooks are 40-50 sheets with 150 lines per sheet, other
workbooks are a single sheet with maybe 20 lines. It does not seem to matter
on the size of the workbook or data, the filter just freezes regularly.

I also tried to establish if there was a pattern to what I was doing before
the filter froze and discovered there wasn't.

Thanks for any suggestions.

 

[SkyDiver]

Hi,

I have had this problem for the past two years. It seems to have gone
away in the past few days. I think it may have been tied to a Windows
XP Update.

Are you still having this issue? If so, I'd like to know. I haven't
tested it too much, yet, but am hopeful that it is fixed.

If you search this forum you will see several posts on this topic over
the past year. I had it narrowed down (I think) to newer versions of
Excel in conjunction with Win2K or newer.

Thanks,
George