Restricting a Filter inside a pivot table

[gharding14]

I have a pivot table that has been set up where I have about 10 possible names that can be filtered that I am basing it off of. I am building '10' sheets, one for each person that I will be sending out via e-mail. I do not want to give a person the ability to look at others data, hence I am only filtering the file based on the person's name.

Is there a way to 'lock' that name on the sheet, in order to restrict them?

Hope I am making this clear to people that can reply to this...
Thanks,

Gary Harding

 

[ParamRay]

.
.

You could protect the worksheet with a password...

 

[gharding14]

But I want the person to be able to filtering info inside, but just not the name. It will not let me 'lock' the cell. It has to be something more concrete than that...

Am I stating that correctly?

 

[Trouttrap2]

You can lock that cell where it's possible to change the names to prevent filtering. Lock with a password.

To do that:
Highlight the entire worksheet first. CTRL+1> deselect locked on Protection Tab > then highlight the cell you want locked > then select locked for that cell only on Protection Tab > Then Review> Protect Sheet> and so on.