Forum Discussion
Solved
Pivot table filters Privacy
Hi, is it possible to lock a filter so when I send a pivot table, the person cannot see the information that is not intended to be seen… example; I have to send an email to 25 team members but I don’...
If you need to retain the interactive functionality of a pivot table, you can split the data so that each pivot table is from data "belonging" only to the target employee.
Alternatively, there are 3rd-party products that can "burst" excel data to individual web pivot tables/charts exported or SFTP uploaded to separate folders. You can secure the output folders (shared folders, SharePoint Folder, or Web folder) using password security.
If you need to retain the interactive functionality of a pivot table, you can split the data so that each pivot table is from data "belonging" only to the target employee.
Alternatively, there are 3rd-party products that can "burst" excel data to individual web pivot tables/charts exported or SFTP uploaded to separate folders. You can secure the output folders (shared folders, SharePoint Folder, or Web folder) using password security.