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.....


VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=563921

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

Thanks Debra for the info

Thought I was going mad



VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=563921