Use of Data Filters on a protected worksheet

  • Thread starter Thread starter Linda
  • Start date Start date
L

Linda

When I protect a worksheet, the cell containing a data
filter no longer works even though the cells containing
the filter and the filter range are unlocked.

Is there something else I need to do to allow the data
filter to function when I protect the worksheet?

Thanks for you help!
 

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

Protecting Excel Formulas 2
protect cell ranges in spreadsheet and have data filters on 2
need help on either doing a loop and counting specific values orusing subtotal function 2
using autofilter data 2
allow a user to edit ranges in a protected worksheet 3
auto filters and worksheet protection 3
Copying a Filter list to a new worksheet. 1
Workbook Security 3

Back
Top