AutoFilter on Protected Worksheet

[JanetW]

I need to protect a worksheet to prevent users from editting certai
columns. It's a log, so I would like to allow them to use AutoFilter t
sort the log. So when I protect the worksheet, I check the box tha
says, "Allow all users of this worksheet to: Use AutoFilters".

Seems pretty straightforward, but when I then go to Data > Filter th
AutoFilter selection is grayed out.

What am I missing?

 

[Debra Dalgleish]

That setting will allow users to apply filters to a table where the
AutoFilter is already turned on. However, they won't be able to create a
new AutoFilter on the sheet.