Locking a Pivot Table Filter

I am trying to send a pivot table to a group of people. Each person will have access to their own data from a master file.

However, I only want these people to have their own data, and not access others.

I try to edit the field settings, and I can not 'lock the filter'

filter.jpg

How can I do this?

Appreciate the help!

Gary Harding
Halesite, NY

I am trying to do this way, rather than have to copy/paste the data for each, and regenerate a 'local' pivot table. I only want person "A" to see "A"'s data, and not the others.

Does that make sense>?>>>>>

Unfortunately - no one answered the first time, but I have the same issue....

I want to be able to lock just one specific filter. The rest of the file - I want to be able to allow for any alteration.

Can this be done? Please help - I am desperate.

Thanks,

Gary Harding
Halesite, NY USA