![]() |
#1
|
|||
|
|||
![]()
I would appreciate your support on the following issue I encounter:
I have protected my spreadsheet (without entering a password) and have ticked the allow "Sorting" option on the relevant pop up menu. However when I try to sort my table of data under Protection mode, the system gives me the message "You are trying to change cells of graphs which are protected, hence read only" and gives me directions how to unprotect the spredasheet. Any hint on how i could tackle this matter? Shouldn' t data sorting work under Protection since I have chosen the Sorting option? My system is an Office2003, Windows2007, legitimate Software Thank you |
#2
|
||||
|
||||
![]()
You can only sort unlocked cells with that option.
|
#3
|
|||
|
|||
![]() |
![]() |
Tags |
protection, sorting |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
sorting data while in a protected workbook | Andy Francis | Excel | 0 | 06-06-2015 01:35 AM |
![]() |
saxydj | Excel | 4 | 02-02-2015 12:40 PM |
![]() |
AQWst | Excel | 4 | 02-02-2015 11:37 AM |
Sorting blocks of data | GenPerson | Excel | 0 | 11-29-2012 02:46 AM |
Can I do this? sorting data in seperate columns | shumonsaha | Excel | 0 | 07-04-2010 03:05 AM |