Can't use PivotChart controls on a Protected Sheet

hamiltpj

New Member
Joined
Oct 29, 2017
Messages
4
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
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,709
Office Version
2007
Platform
Windows
When you protect the sheet you must check the box: "Use PivotTable & Pivot Chart"


 

hamiltpj

New Member
Joined
Oct 29, 2017
Messages
4
As I said, I did that but it didn't work. That's the problem. Does it work for you?
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,709
Office Version
2007
Platform
Windows
Yes, it works for me.
Which Excel version do you have?
 

Watch MrExcel Video

Forum statistics

Threads
1,099,064
Messages
5,466,379
Members
406,478
Latest member
Amar kumar

This Week's Hot Topics

Top