Protecttion + PivotTable Reports option

[VBA Noob]

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

 

[Debra Dalgleish]

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]

Thanks Debra for the info

Thought I was going mad



VBA Noob