I have created a spreadsheet with a couple of pivot tables, which will be used as a shared spreadsheet on Sharepoint. I've used slicers so people can easily filter to see what they want to see, however I am concerned that slicers will amend the pivot table for everyone and if there are multiple people using the spreadsheet at the same time if will cause frustration. Is there a way around this?
Bookmarks