View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
 
Posts: 972
Default How to - sort a protected sheet?

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