Can't sort while protected

bobgrand

Board Regular
Joined
Apr 14, 2008
Messages
220
Hello all,

I have a protected sheet with filters on. Certain columns must be used for sorting. I selected the proper fields when protecting the sheet to allow for sorting but it will not allow anyone to do any sorting.

I tried many different ways from articles I found online but still not able to sort.

If anyone can shed some light on this I would greatly appreciate it.

Thank you in advance
Bob
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
20,049
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
Did you tick "Sort" in the list of options before protecting the worksheet ?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,535
Office Version
  1. 365
Platform
  1. Windows
Are any of the cells in the sort range locked?
 

bobgrand

Board Regular
Joined
Apr 14, 2008
Messages
220
Fluff - Columns A thru E are locked. Columns F & G are unlocked. Columns H thru P are locked. F & G are for editing only. Column M is the main column to sort on. I am just so baffled by this.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,535
Office Version
  1. 365
Platform
  1. Windows
If any cells in the area to be sorted are locked & the sheet protected, then you cannot sort without unprotecting the sheet.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,556
Messages
5,625,496
Members
416,112
Latest member
somenka

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top