Forum Discussion

MMCCarte34's avatar
MMCCarte34
Copper Contributor
May 12, 2020

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

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 multipl...
excel
Excel for web
Woody125's avatar
Woody125
Copper Contributor
May 06, 2022

Having the same issue here. Daily requests to reset filters for users (where they bother to get in touch and don't just abandon the process). Look forward to someone coming up with a solution

  • kevin121's avatar
    kevin121
    Copper Contributor
    Jan 30, 2023

    Woody125 

     

    There is a way, make the file read only. When the file is read only, all filter is limited to individual. If you still want to give them permission to edit the file. Make the file protected as default(meaning as view only as default).

     

    File -> options -> protect file

     

Resources