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.