Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting protected worksheets
Greetings!
I need to allow others to sort my worksheet which contain a few protected columns. I am also using setup data validation and several other functions. This file is stored on a shared drive. So farI have tried the following: Tools/protection/protect sheets Select locked cells select unlocked cells select format cell, select columns select rows SELECT SORT Select Autofilter Select pivot reports Whenever other users attempt to sort this worksheets, they get a message stating this worksheet is protected. By selecting the "SELECT SORT" option listed above, shouldn't they be able to sort this data? Thanks for your help. Drr |
#2
|
|||
|
|||
Hi
is this a shared file (Tools - share workbook)? -- Regards Frank Kabel Frankfurt, Germany "Drr" schrieb im Newsbeitrag ... Greetings! I need to allow others to sort my worksheet which contain a few protected columns. I am also using setup data validation and several other functions. This file is stored on a shared drive. So farI have tried the following: Tools/protection/protect sheets Select locked cells select unlocked cells select format cell, select columns select rows SELECT SORT Select Autofilter Select pivot reports Whenever other users attempt to sort this worksheets, they get a message stating this worksheet is protected. By selecting the "SELECT SORT" option listed above, shouldn't they be able to sort this data? Thanks for your help. Drr |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Linking to Worksheets on Excel -Saved Web Page | Links and Linking in Excel | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
sorting question | Excel Discussion (Misc queries) | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) |