Limit access in a pivot table

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I have a pivot table that I want to send to someone. Is it possible that you
can limit the viewing to a certain criteria.
I want them to only be able to see information for supplier “A†but not “Bâ€
and “C†and still be able to use the functions of the pivot table
 
Debra Dalgleish has instructions for using macros to disable selections and
restrict pivot tables on her Contextures site:

http://www.contextures.com/xlPivot12.html

However, I think the safest approach is to segregate the data for supplier A
first and create the pivot table from that.

Hope this helps,

Hutch
 
Back
Top