View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
muddan madhu muddan madhu is offline
external usenet poster
 
Posts: 747
Default 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