Prevent access to raw data in a pivot table?
I have saved a pivot table (tab only) to a new file, thus removing the tab with the raw data. I need to share the pivot table such that users can filter (filter is on person names) the table; however, I would like users to not be able to access the raw data.
Even though I've removed the tab of raw data, I know that one can double-click on a subtotal or total, including the grand total, and open a new tab with the cache of the full raw data.
Is there a way I can allow users to continue to filter but not be able to access the cache?
|