![]() |
#1
|
|||
|
|||
![]()
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? |
|
![]() |
||||
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 |
![]() |
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 |