Can't use PivotChart controls on a Protected Sheet

[hamiltpj]

Hi there,

I have created a sheet with pivot charts that I want to be locked in place, but have their filter controls remain useable. When I protect the sheet though and check 'Use PivotTable & PivotChart', the pivot chart controls are locked.

Can someone help?

Pete

 

[DanteAmor]

When you protect the sheet you must check the box: "Use PivotTable & Pivot Chart"

 

[hamiltpj]

As I said, I did that but it didn't work. That's the problem. Does it work for you?

 

[DanteAmor]

Yes, it works for me.
Which Excel version do you have?