How do you automatically remove filters from an online excel doc on sharepoint?

%3CLINGO-SUB%20id%3D%22lingo-sub-1382513%22%20slang%3D%22en-US%22%3EHow%20do%20you%20automatically%20remove%20filters%20from%20an%20online%20excel%20doc%20on%20sharepoint%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1382513%22%20slang%3D%22en-US%22%3E%3CP%3EApologies%20but%20this%20is%20all%20new%20to%20me%20and%20I%20am%20a%20teacher%20thrown%20in%20at%20the%20deep%20end%20with%20the%20current%20situation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20currently%20have%20a%20whole%20school%20excel%20online%20spreadsheet%20on%20sharepoint%20so%20that%20multiple%20users%20can%20enter%20data.%20The%20problem%20is%20(I%20think)%20that%20staff%20are%20forgetting%20to%20remove%20filters%20and%20are%20somehow%20overwriting%20other%20staffs%20values.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20anyway%20to%20set%20up%20the%20doc%20so%20that%20all%20filters%20automatically%20clear%20after%20each%20user%3F%20Also%20incase%20im%20missing%20something%20could%20there%20be%20another%20reason%20why%20different%20data%20is%20being%20entered%20and%20removed%20across%20the%20entire%20document%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1382513%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1382594%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20automatically%20remove%20filters%20from%20an%20online%20excel%20doc%20on%20sharepoint%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1382594%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F664695%22%20target%3D%22_blank%22%3E%40MMCCarte34%3C%2FA%3E%26nbsp%3BHi%20there.%20First%20you%20should%20tell%20your%20students%20to%20apply%20the%20filters%20ONLY%20to%20them%20(individual).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20clean%20all%20the%20filters%20applied%20go%20to%3C%2FP%3E%3CDIV%20class%3D%22lia-spoiler-container%22%3E%3CA%20class%3D%22lia-spoiler-link%22%20href%3D%22%23%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3ESpoiler%3C%2FA%3E%3CNOSCRIPT%3E(Highlight%20to%20read)%3C%2FNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-border%22%3E%3CDIV%20class%3D%22lia-spoiler-content%22%3E%3CSTRONG%3EDATA%20%3C%2FSTRONG%3Etab%20%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Photo1.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190920i5EB18DD6D023E65B%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Photo1.png%22%20alt%3D%22Photo1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-noscript-container%22%3E%3CDIV%20class%3D%22lia-spoiler-noscript-content%22%3EDATA%20tab%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FNOSCRIPT%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3Eclick%3C%2FP%3E%3CDIV%20class%3D%22lia-spoiler-container%22%3E%3CA%20class%3D%22lia-spoiler-link%22%20href%3D%22%23%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3ESpoiler%3C%2FA%3E%3CNOSCRIPT%3E(Highlight%20to%20read)%3C%2FNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-border%22%3E%3CDIV%20class%3D%22lia-spoiler-content%22%3E%3CSTRONG%3ECLEAR%3C%2FSTRONG%3E%20%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Photo2.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190921iF8C112AE020D2246%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Photo2.png%22%20alt%3D%22Photo2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-noscript-container%22%3E%3CDIV%20class%3D%22lia-spoiler-noscript-content%22%3ECLEAR%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FNOSCRIPT%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%3CSTRONG%3E%26nbsp%3B%3C%2FSTRONG%3Ein%20the%20%3CSTRONG%3ESORT%20%26amp%3B%20FILTERS%3C%2FSTRONG%3E%20box%3CSTRONG%3E.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELG%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1382641%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20automatically%20remove%20filters%20from%20an%20online%20excel%20doc%20on%20sharepoint%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1382641%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20this%20however%20the%20issue%20is%20that%20staff%20are%20not%20clearing%20filters.%20This%20then%20affects%20the%20next%20user%20and%20so%20on.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20it%20to%20be%20done%20for%20them.%20Some%20staff%20are%20not%20coping%20well%20with%20this%20transition%20and%20are%20not%20IT%20literate%20no%20matter%20how%20many%20times%20they%20are%20supported.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20anyway%20to%20set%20it%20up%20that%20the%20document%20automatically%20removes%20all%20filters%20when%20the%20exit%20the%20document%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F663899%22%20target%3D%22_blank%22%3E%40Luis_Guicho%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1382714%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20automatically%20remove%20filters%20from%20an%20online%20excel%20doc%20on%20sharepoint%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1382714%22%20slang%3D%22en-US%22%3EYou%20should%20tell%20your%20fellow%20teachers%20and%20students%20when%20they%20choose%20filters%20choose%20the%20option%20%22apply%20only%20to%20me%22.%20This%20will%20not%20affect%20other%20users.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1382719%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20automatically%20remove%20filters%20from%20an%20online%20excel%20doc%20on%20sharepoint%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1382719%22%20slang%3D%22en-US%22%3E%3CP%3EOK.%20Will%20they%20still%20need%20to%20clear%20their%20filters%20when%20they%20have%20finished%20adding%20data%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much.%20Its%20a%20total%20headache%20for%20a%20large%20school%20staff.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F663899%22%20target%3D%22_blank%22%3E%40Luis_Guicho%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1382762%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20automatically%20remove%20filters%20from%20an%20online%20excel%20doc%20on%20sharepoint%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1382762%22%20slang%3D%22en-US%22%3ENo%20they%20don't.%20Just%20warn%20them%20to%20apply%20the%20filters%20ONLY%20to%20them%20when%20they%20choose%20the%20filters.%20(a%20pop%20up%20message%20will%20apear%20asking%20if%20they%20want%20to%20apply%20the%20filters%20only%20to%20them%20or%20to%20all%20users).%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Apologies but this is all new to me and I am a teacher thrown in at the deep end with the current situation.

 

I currently have a whole school excel online spreadsheet on sharepoint so that multiple users can enter data. The problem is (I think) that staff are forgetting to remove filters and are somehow overwriting other staffs values.

 

Is there anyway to set up the doc so that all filters automatically clear after each user? Also incase im missing something could there be another reason why different data is being entered and removed across the entire document?

 

Thanks in advance!

 

 

5 Replies
Highlighted

@MMCCarte34 Hi there. First you should tell your students to apply the filters ONLY to them (individual).

 

To clean all the filters applied go to

Spoiler
DATA tab Photo1.png

click

Spoiler
CLEAR Photo2.png

 in the SORT & FILTERS box.

 

LG

Highlighted

Thank you for this however the issue is that staff are not clearing filters. This then affects the next user and so on.

 

I need it to be done for them. Some staff are not coping well with this transition and are not IT literate no matter how many times they are supported.

 

Is there anyway to set it up that the document automatically removes all filters when the exit the document?

 

@Luis_Guicho 

Highlighted
You should tell your fellow teachers and students when they choose filters choose the option "apply only to me". This will not affect other users.
Highlighted

OK. Will they still need to clear their filters when they have finished adding data?

 

Thank you so much. Its a total headache for a large school staff.

 

@Luis_Guicho 

Highlighted
No they don't. Just warn them to apply the filters ONLY to them when they choose the filters. (a pop up message will apear asking if they want to apply the filters only to them or to all users).