Pivot Table Security - customize field options based on user accou
 

Hi,

I have a pivot table that displays information for various salespeople.
However, when each salesperson looks at the pivot table, I want them only to
see information that pertains to them. So, for example, if "Salesperson" is a
column pivot table field, salesperson John should only have the option of
selecting John's information, salesperson Bob should only have the option of
selecting Bob's information, etc. Is this possible? Or does this type of
security/privileges fall outside the realm of Excel pivot tables?

Thanks,
Hazel