Localise Pivot Table Filter

Copper Contributor

Hi All,

I have a shared excel file on Sharepoint with a Pivot Table containing a list of usernames. Each person who needs to review, selects there username on the Pivot to filter which filters to the data specific to them. The problem is when another person accesses the file and filters to their username it applies that filter to all who are currently reviewing the file, hence it is a nuisance. Is it possible to have the filter localised to the individual when they set their filters and not having the filter applied universally.. Appreciate any advice or assistance.

0 Replies