Auto filter

[Nenagh]

Hi,

Just lately, when i open spreadsheets which already have a filter in place,
i find that the drop down arrows don't display, i click on the autofilter
command and then again and they are then enabled. I try to remove the
autofilter but it only removes it from some columns and not all - i'm pulling
my air out. Any ideas what is causing this?

Cheers

 

[YESHWANT]

Hi Nenagh,

i think your worksheet/workbook is protected and hence it is not allowing
you to remove or use auto filter.

kindly check and revert back, if needed

 

[Daniel.C]

Hi,
Your workbook is possibly corrupted. Try copying the sheets in a new
file and test.
HTH
Daniel