How to - sort a protected sheet?

B

Bob

I have a sheet where all the cells are linked to a source sheet. I want to
allow sorting, filtering and pivot tables, but no changes / edits to the
cells. I tried the “Protect†the sheet and checked the boxes to allow all
users to Sort, Filter and use Pivot tables but, when I turn on the protection
and try to sort I get and error “The command could not be completed by using
the range specified. Select a single cell within the range and try the
command again.

Make no sense to me. What am I doing wrong?

Thanks

Bob
 

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 a protected set of cells 3
Sheet Protection / Edit Objects 0
Utilizng full AutoFilter features while specific cells are protect 0
Sheet Protection / Edit Objects 1
Protected Sheets 2
Allowing sort of protected cells 1
Sorting a protected sheet 1
Enabling Autofilter and Sorting in a Protected Sheet 2

Top