View Single Post
 
Old 02-02-2015, 02:06 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

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.
Reply With Quote