Filters not working on Protected sheet

  • Thread starter Thread starter Krishna Kumar L
  • Start date 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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting in a protected sheet 1
Consolidate report in Different sheet 3
Help with using Auto-filter in a protected Worksheet. 5
Using Autofilter on Protected sheets 3
Macro to copy value in field and insert it into filter 2
Allow users of protected sheet to use macro involving custom filte 3
Excel Move or Copy Stopped Working? 0
Autofilter not working on protected sheet. 1

Back
Top