Allowing users to use pivot tables on a protected sheet lets them work
with existing pivot tables, but they won't be able to create new pivot
tables on the protected sheet.

VBA Noob wrote:
Hi all,

I've protect a sheet and ticked the PivotTable Reports option to allow
pivots however it's still greyed out so I can't select this option.

Any ideas why that might be.....

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