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?

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.

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.