View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PJS PJS is offline
external usenet poster
 
Posts: 23
Default Pivot Table limiting user selection

Hi,

I have a pivot table with different region and different Operational
Directors' performance. I would like to limit the user to their own data
without seeing others' numbers. How would I do that?

For example, let say, there are 3 operational directors A, B and C, if
person A opens the spreadsheet, is it possible for him/her to enter a
password to access his/her info only?

thanks,

PJS