Generate report filter pages Pivot tables

New Contributor

In order to send data to different users, I need to generate pages from a pivot table.

This has to be done, so that no user can have access to the filtered data

Can this be done without protecting the files with a password ?


2 Replies
To generate individual report in PivotTable, drag and drop desired field into the Filter area.. Then, on the options dropdown of the Analyze tab, click on Show Report Filter pages..

This would create multiple report pages based on the filter.. Then, you can finally email the individual sheet tabs to different users



Thank you very much for your reply.

By using this system however, the different tabs generated still contain all the data from the initial file, and each user therefore would have access to data that is not to be shared to him

As I do not know how the data is used by the each user, I cannot protect the file