Hello Gurus,
Is there a way I could remove the PivotTable tools so that everytime pivot table cell is selected, it won't show up at the top-right of the menu tab.
You can see from the image provided that a click on a pivot table cell will make appear the contextual tab named PivotTable Tools with mainly two selections
1. Analyze
2. Design
How do I remove Analyze and leave out the Design. Or How do I remove both of these from the ribbon. Is it possible?
I want the end user to select from pivot tables but do not want to leave pivot table settings open to any changes.
Thanks and will appreciate.
Is there a way I could remove the PivotTable tools so that everytime pivot table cell is selected, it won't show up at the top-right of the menu tab.
You can see from the image provided that a click on a pivot table cell will make appear the contextual tab named PivotTable Tools with mainly two selections
1. Analyze
2. Design
How do I remove Analyze and leave out the Design. Or How do I remove both of these from the ribbon. Is it possible?
I want the end user to select from pivot tables but do not want to leave pivot table settings open to any changes.
Thanks and will appreciate.