Forum

Notifications
Clear all

Disable - Excel Slicer Right Click on Protect Workbook

3 Posts
2 Users
0 Reactions
222 Views
(@akash)
Posts: 2
New Member
Topic starter
 

Hello,

 
My Query
 
I have an Excel file which has a dashboard and it has multiple slicers which fetch data from one pivot table. All the slicer and Pivot Table are linked with each other. When I have protected my file with the allowance of pivot and filter, All slicers can be still excess by Right click. So that cut, Remove, Change Remote Connection and all other options can be done by selecting Right click on slicer.
 
Now I don't want to allow the right click on any slicers of my workbook and still the slicers can work as normal. How can I Do it?
 
Pls help me with this.
 
Thanks
 
Posted : 01/02/2024 9:49 am
(@mynda)
Posts: 4761
Member Admin
 

Nothing you can do to prevent that, Akash.

Note: please don't email and post on the forum as this requires twice the work for you and me. The forum is the best place to ask these questions as our answers can also help others. Thanks for understanding.

 
Posted : 01/02/2024 8:05 pm
(@akash)
Posts: 2
New Member
Topic starter
 

Thanks for Reply.

Noted Mam.

 
Posted : 02/02/2024 12:51 am
Share: