If you don't want one department to view data from another department,
you should create a separate pivot table for each department, based on
its data only.

You could protect the pivot table, to prevent changes to the page field,
but it's easy to circumvent Excel's worksheet protection.

kedahboy wrote:
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.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html