Solved

Use Autofilter in Protect mode

Posted on 2012-03-21
10
235 Views
Last Modified: 2012-03-22
I am using Excel 2003.  I have followed instructions to use autofilter in a protected worksheet by clicking the appropriate box in the drop down (Tools/Protection/Protect Sheet, Allow All Users to Use/Autofilter).  Despite allowing Autofilter, it will not work when the worksheet is protected.
0
Comment
Question by:treeher
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
10 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 37747644
It only allows you to use an existing autofilter, not actually apply or remove an autofilter to the sheet.
0
 

Author Comment

by:treeher
ID: 37747701
To clarify, I have already activated autofilter in the worksheet prior to enabling protection.  The autofilter works fine in unprotected mode but will not work after protection is enabled.  My understanding is that allowing users to use autofilter in protect mode should have solved this, but the autofilter will not work after I enable protect.
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 37747788
Curious. What actually happens? Does the dropdown not work, or does the filter not apply, or do you get an error?
0
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 

Author Comment

by:treeher
ID: 37747861
You can click the Autofilter button and the drop down box opens up for the autofilter and you can select from it, for example Sort Ascending, but then nothing happens at all.  If I unprotect, it works fine.
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 37747894
Does the filtering (rather than sorting) work? Sorting is a separate setting.
0
 

Author Comment

by:treeher
ID: 37748080
AHA!  You got it.  Yes, the filtering works.  Now, how do I make the Sorting work?
0
 
LVL 85

Assisted Solution

by:Rory Archibald
Rory Archibald earned 500 total points
ID: 37748109
You have to check the Sort option in the protection dialog and you also have to unlock any cells that you want to be able to sort.
0
 

Author Comment

by:treeher
ID: 37748136
When I select the "Sort" option in  the Protection drop down and then protect the sheet, the autofilter still will not sort ... now I get the error message "The cell or chart you are trying to change is protected and therefore read only.  To modify a protected cell or chart, first remove protection using the Unprotect Sheet command."  If true, then of what use is it to allow "sort" for users?
0
 

Author Comment

by:treeher
ID: 37748149
OK, finally I have got it.  You have been a GREAT help to me!  Thank you.
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 37748190
My pleasure. :)
0

Featured Post

Increase your protection from Zero Day threats!

Running two Antivirus' is never a good idea.
Taking advantage of Multiple Security layers on the other hand can often save your hide.
See which top notch security software brands have been proven to happily coexist together.
Reduce your chances of becoming a statistic.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question