Autofilter and Protected Sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-2889995%22%20slang%3D%22en-US%22%3EAutofilter%20and%20Protected%20Sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2889995%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20a%20manufacturing%20company%2C%20we%20have%20master%20spreadsheets%20on%20Sharepoint.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThese%20spreadsheets%20have%20multiple%20users%20and%20certain%20cells%20are%20password%20protected%20to%20certain%20users%20depending%20on%20their%20use%20of%20the%20spreadsheet.%20These%20users%20are%20able%20to%20set%20filters%20within%20the%20sheet.%20Our%20problem%20is%20the%20clear%20all%20filters%20button%20%2F%20action%20no%20longer%20works%20when%20there%20are%20multiple%20filters.%20They%20have%20to%20manually%20undo%20filters%20from%20cells%20they%20have%20set%20them%20on.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20anyway%20around%20this%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2889995%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi, 

 

We are a manufacturing company, we have master spreadsheets on Sharepoint.

 

These spreadsheets have multiple users and certain cells are password protected to certain users depending on their use of the spreadsheet. These users are able to set filters within the sheet. Our problem is the clear all filters button / action no longer works when there are multiple filters. They have to manually undo filters from cells they have set them on.  

 

Is there anyway around this? 

 

Thanks!

 

0 Replies