Filtering

  • Thread starter Thread starter Sven
  • Start date Start date
S

Sven

I have a problem with the filters "freezing" on
spreadsheets, it doesnt seem to have any pattern to it
but once a sheet is affected it never seems able to
correct itself, the only way i can overcome it is to turn
off the autofilter, unhide all the rows then select and
re-apply the autofilter.
Is this a bug or am i just lucky
 
Does freezing mean that the arrows appear, but don't do anything when you click
on them...And Data|filter|autofilter is checked?

If yes to all of those, I've seen this, too. I do the same thing you do,
although sometimes just closing the workbook and reopening it works, too.

(But once you remove the autofilter, aren't the rows visible????)
 
Sven,

Not sure if this is your challenge, but some thoughts.

I believe that the issue is XL appearing to be locked up
when in reality it is calculating the filter.

Using XL 2002 & XL 97, I noticed that if I saved a large file
with the filters ON, it could take as much as 20 Minutes!!
for that to (re)open, but open it did.

Note that Task Manager reported XL as Not Responding.

In fact, XL was processing the filter in memory.

My main point: Save/Open large XL files with filters OFF.
 
Back
Top