Filters not working on Protected sheet

  • Thread starter Krishna Kumar L
  • Start date
K

Krishna Kumar L

Hi,

I am using tables and filters in my sheet. I am unable to use the filters once I have protected the worksheet. Kindly help.

KK
 
M

muddan madhu

Before protecting the sheet check the option filter.

Tools | protection | protect sheet | give the password ( optional ) |
allow all the users for this worksheet to : check use autofilter
option | ok
 
Top