Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / January 2004

Tip: Looking for answers? Try searching our database.

excel 2003 upgrade problems

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
nicholas gibbs - 31 Jan 2004 16:16 GMT
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 - 31 Jan 2004 22:13 GMT
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.)

> i have just upgraded to 2003 mainly to gain the increased
> functionality within protected worksheets. in the new
[quoted text clipped - 8 lines]
>
> any ideas/existing experience greatly appreciated.

Signature

Dave Peterson
ec35720@msn.com

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.