I have a spreadsheet on which I had AutFilter enabled.

As of yesterday I can no longer use the AutoFilter option and strangely when
I click on Data then Filter the option to use AutoFilter is greyed out but
has a tick to the left of it showing it is enabled.

On a similar worksheet I have the same problem as above but there is no tick
showing that the AutoFilter is enabled.

Both worksheets are not protected in any way.

I have a screen shot saved but not sure if I can paste it onto this forum.
Seeing a visual of my issue may help.


Thanks