Data Sorting while on Protection mode
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
|