I have created a pivot table from a master excel sheet with several different
"Users" listed with their accompanying Turnover information. I now need to
send each User a separate summary of their pivot table data so that they have
the ability to double click and open up their detailed data. But I can't
figure out how to restrict them from accessing OTHER Users' data by
selecting another User from the pivot table list, while still keeping the
link to the master data sheet.

Can anyone help me with this? I know I don't have to create 65 separate data
sheets and create a separate pivot table from each of those (otherwise why
would I create a pivot table at all?!)

:)