If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
excel 2003 upgrade problems
i have just upgraded to 2003 mainly to gain the increased
functionality within protected worksheets. in the new product, when protecting a worksheet, it is possible to allow users to still have the ability to use auto filter and sort (wheras protection in earlier versions prevented this). despite checking the relative submenu options under worksheet protection, the autofilter and sort functions are still 'greyed out' and unavailable. any ideas/existing experience greatly appreciated. |
#2
|
|||
|
|||
excel 2003 upgrade problems
Did you apply the autofilter before you protected the worksheet?
And all your cells in the sort range must be unlocked to be able to sort. If you have even one locked cell in that range, it won't work. (And I've always better luck explicitly selecting my range--not letting excel guess it.) (I use xl2002.) nicholas gibbs wrote: i have just upgraded to 2003 mainly to gain the increased functionality within protected worksheets. in the new product, when protecting a worksheet, it is possible to allow users to still have the ability to use auto filter and sort (wheras protection in earlier versions prevented this). despite checking the relative submenu options under worksheet protection, the autofilter and sort functions are still 'greyed out' and unavailable. any ideas/existing experience greatly appreciated. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|