Limit access in a pivot table
 

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

Limit access in a pivot table
 

Protect the sheet & send it.


On Oct 23, 7:48*pm, Ken wrote:
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

Limit access in a 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

"Ken" wrote:

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