View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dan dan is offline
external usenet poster
 
Posts: 866
Default Pivot Table Data Filter

I have pivot table linked to a network database source that shows the payroll
information for management. The challenge is I do not want all of the data
viewable to all managers such as each other's salaries. Is there any way I
can check the autofilter dropdown to show what I want then protect that
filter? I appreciate your help.