I have an excel file that is hosted on Sharepoint and accessible to anyone with a link. I don't want anyone to be able to change the data in the file, so I've removed Edit access for everyone but me.
The tricky thing is that I do want people to be able to filter in the table (e.g. the first column lists the state where this list of companies is located - I want people to be able to select a state from the filter dropdown menu and only see rows matching that state). I don't want these filters to affect how others view the file, though, so every user that clicks on the link to the file should see the unfiltered table then be able to filter it themselves.
Right now, it seems as though this is impossible without the user saving a copy of their file first.
Are there any workarounds or other possible services (besides Sharepoint) that would have this functionality?