My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Disable - Excel Slicer Right Click on Protect Workbook|Dashboards & Charts|Excel Forum|My Online Training Hub

You are here: Home / Disable - Excel Slicer Right Click on Protect Workbook|Dashboards & Charts|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Disable - Excel Slicer Right Click on Protect Workbook
Avatar
Akash Patel

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
January 31, 2024
sp_UserOfflineSmall Offline
1
January 31, 2024 - 11:49 pm
sp_Permalink sp_Print

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
Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4772
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
2
February 1, 2024 - 10:05 am
sp_Permalink sp_Print

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.

Avatar
Akash Patel

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
January 31, 2024
sp_UserOfflineSmall Offline
3
February 1, 2024 - 2:51 pm
sp_Permalink sp_Print

Thanks for Reply.

Noted Mam.

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Kevin Campbell
Guest(s) 5
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 930
Purfleet: 415
Hans Hallebeek: 354
Frans Visser: 349
David_Ng: 312
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
QkBXoylJZ ionivxwYdRFNFL
kEUeirrVvEo LuuDySmTmIizW
uavBfwotTrMPA NIQkZzprwMG
qVMPnaSzpgZ uaHBwyav
rCkwbAORdf eaYibAkYjfXT
eNvhcbgYvaPRp nImfgnjOk
kwKbBpnpPjgKuhr LSOUORDzhcRqQ
CPUXMYKMkLuXs iAsOmBtNLn
Clive Webb
EXerOrqW PRqmMlMeyNd
Forum Stats:
Groups: 3
Forums: 25
Topics: 7095
Posts: 31105

 

Member Stats:
Guest Posters: 49
Members: 34537
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen