Prevent access to raw data in a pivot table?

[Chancy]

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?

[Chancy]

I'm guessing no replies means "not possible to control access to the cached raw data in a pivot table".

However, I think I figured it out, which is to protect the sheet, turning off everything except the right to edit the pivot table and use auto-filter. This allows the user to filter, but, not to highlight and copy cell contents. This wouldn't stop a use from screen-shotting all the data, but, it's a very good option to limit access.

[gebobs]

Well done!

[Chancy]

Originally Posted by gebobs

Well done!

Thanks!
Also - turn on "format columns", because column width looks different on different monitors and the values may not be fully visible without re-sizing column widths.