Limit access in a pivot table

[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

 

[muddan madhu]

Protect the sheet & send it.

 

[Tom Hutchins]

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