Excel Filter

  • Thread starter Thread starter AdamP
  • Start date Start date
A

AdamP

Does anyone know why my filter does not work on occasions?
Most of the time it is fine but occasionally after the
filter has been applied the menu will not respond.

This has happened to my computer and a colleages.

Any ideas??
 
Do you mean the dropdown won't appear when you click on the arrow?

If yes, then I've seen it. But I don't know what causes it. Sometimes you can
remove the filter and reapply it and it'll start working again. But sometimes
that doesn't help, either.

I've learned to swear and ignore it. If it's important, then you might try
copying the data to a new worksheet and applying the filter there. (If it
works, delete the original worksheet.)
 
i also have suffered from the problem dave mentioned. Does anyone know
why this is, and if it can be solved as it has proved very annoying.

my experience was with drop down menus(data/validation...list), dont
know if this was daves problem.

any help would be appreciated.

Robert.
 
My problem (well, one of my problems) has been with the autofilter arrows not
always showing up.

I don't recall any problem with Data|Validation with arrows not showing up.

Are you sure you have "in cell dropdown" checked inside:
Data|Validation|Settings Tab
 
yeah i have that. The problem is that one day they will work fine and
then for no reason they disappear, there is nuthing u can do about it,
deleting and trying again etc
 
I have one workbook that's created every month. Almost everytime I create it,
one of the sheets has this problem. But other sheets within the same workbook
work ok.

Go figure???
 
Back
Top