If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot table question.
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 |
#2
|
|||
|
|||
Pivot table question.
Not without deleting the information from the PivotTable source.
Now, you could get the appearance by Double clicking on your page field, and then selecting all the options you don't want to be visible. This would give the appearance to Dr A that he can't see Dr B. But, all he has to do is reverse this process, so if you're dealing with delicate information, this is NOT RECOMMENDED. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Jim W" wrote: 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 |
#3
|
|||
|
|||
Pivot table question.
Luke - I was thinking more in terms of selecting Dr A in the drop down and
then hiding the data sheet and using protection with a password to "lock" the cell that would be used to select another DR. No good? Thanks "Luke M" wrote: Not without deleting the information from the PivotTable source. Now, you could get the appearance by Double clicking on your page field, and then selecting all the options you don't want to be visible. This would give the appearance to Dr A that he can't see Dr B. But, all he has to do is reverse this process, so if you're dealing with delicate information, this is NOT RECOMMENDED. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Jim W" wrote: 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 |
#4
|
|||
|
|||
Pivot table question.
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 |
Thread Tools | |
Display Modes | |
|
|