98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Using the "sort" on a protected sheet
Using the "sort" on a protected sheet
Resolved · High Priority · Version 2003
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Difference between Two DatesThe DATEDIF function computes the difference between two dates. The DATEDIF function is as follows: |