Hi Jim

Move the Dr field to become a Page field.
From the PT toolbarPivot Table dropdownShow Page fields
This will create a separate sheet for Each Dr, with their summary.
Just Mail the individual sheet to each Dr.

--
Regards
Roger Govier

"Jim W" wrote in message
...
I have a pivot table on a physician practice, the first column is the dr
name
in a drop down box:
All
Dr A
Dr B
etc
Is there a way for me to lock the selection to only include Dr A so that I
could send the file to Dr A without having him be able to access Dr B
information.
Thanks,
Jim