View Single Post
 
Old 01-30-2015, 12:30 PM
Chancy Chancy is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: Jan 2015
Posts: 32
Chancy is on a distinguished road
Default 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?
Reply With Quote