Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I prevent access to other page area in pivot table report?
I have created a pivot table report in which I have added a field in the Page
Area. This field represents the different departments in the company and I do not want one department to view the data from another department. As such I need to protect the Page Area so that the department can only view the data for that department but must be able to show and hide details. I find that if I protect the worksheet then one is unable to show and hide details! Thanks guys. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables vs. Report in Access | Excel Discussion (Misc queries) | |||
Pivot Table Page Field Area Broken | Excel Discussion (Misc queries) | |||
A pivot table report cannot overlap another pivot table report. | Excel Discussion (Misc queries) | |||
Multiple selection in the page area of a pivot table | Excel Discussion (Misc queries) | |||
I cannot drag a Pivot Table field into the page area | Excel Discussion (Misc queries) |