![]() |
|
#2
|
|||
|
|||
|
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. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Pivot Table Question- Can the table display in the order the boxes were checked/selected? | blackjack | Excel | 0 | 09-13-2014 08:57 PM |
| Pivot Table Duplicate Data | cnw | Excel | 0 | 08-31-2012 08:24 AM |
VBA: Include Dynamic Sheet Name In Pivot Table Source Data
|
ibrahimaa | Excel Programming | 2 | 04-28-2012 12:27 AM |
| Populate dropdown list with data from Access table | spw4000 | Office | 0 | 02-24-2012 05:22 AM |
| pivot table source data | hannu | Excel | 0 | 07-03-2010 04:54 AM |