Victoria has attended:
Excel Intermediate course
Excel Advanced course
Using the "sort" on a protected sheet
Dear Best Training,
Could you please tell me how I may allow other users to sort (where an auto filter has already been created) a spreadsheet while it is protected.
The method I have tried is:
Tools - Protection - Protect Sheet - Allow all users of this worksheet to: Sort - OK
Once the sheet is protected though, I cannot sort the data.
Thank you very much for your help.
RE: Using the "sort" on a protected sheet
Hi Victoria, Thanks for the post, It seems as though you have followed the correct method of allowing users to sort; so I am a little bit flummoxed as to why it's not working;
For others who may be interested; If you are using Excel 2002, Excel 2003, or Excel 2007 the answer is reasonably straightforward: These versions of Excel allow you to specify what users can and cannot do with a protected worksheet. When you choose Tools>Protection>Protect Sheet (Excel 2002 and Excel 2003) or click the tab to display the Review ribbon and click Protect Sheet in the Changes group (Excel 2007), Excel displays the Protect Sheet dialog box. At the bottom of the dialog box is a long list of check boxes.
All you need to do is select what the user should be able to do with the worksheet. One of the options (you need to scroll down a bit) is Sort. If you select this option, then users can sort protected data.
Thats the theory behind it, so I cannot see why your worksheet is not operating correctly, please come back if you are still having a problem, best regards Pete
RE: Using the "sort" on a protected sheet
Hi Pete,
I am still having the problem, as is my manager who has also been on Excel Advanced training. Neither of us can figure it out.
Could I email you a spreadsheet I am using to test the method? It's only got a little data made up about fruit.
Thanks,
Vicky
RE: Using the "sort" on a protected sheet
Hi Vicky, send it to me at pete1@stl-training.co.uk Pete
