Auto filter

  • Thread starter Thread starter Nenagh
  • Start date Start date
N

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
 
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
 
Hi,
Your workbook is possibly corrupted. Try copying the sheets in a new
file and test.
HTH
Daniel
 
Back
Top