Log In
Register
Home
How to lock the slicer
Shiyamsunthar Ganesan
New Member
Members
Forum Posts: 1
Member Since:
January 5, 2021
January 5, 2021
Offline1
January 5, 2021 - 1:04 am
MY ISSUE IS
The slicer is UN CHECKED on LOCKED and CHECKED on Don’t move or size with cell, and CHECKED the Disable resizing & moving and also CHECKED on select unlocked cells under the PROTECT SHEET.
However, when I click the right mouse key while howovering over the slicer the below pop up appears which allows the user to cut and remove the slicer from the dash board altogether.
Catalin Bombea
Iasi, Romania
Member
Dashboards
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
Forum Posts: 1939
Member Since:
November 8, 2013
November 8, 2013
Offline2
January 6, 2021 - 5:40 am
Hi,
The slicer should be CHECKED on LOCKED, to protect it from changes
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Philip Treacy
Guest(s) 6
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 925
Purfleet: 415
Frans Visser: 349
Hans Hallebeek: 343
David_Ng: 312
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Lisa Donaldson
Hiroyuki Murai
Mark Allen
Yves Gagnon
PATRICK WALTER
Carley Brice
Ash Rahman
Christelle Lamprecht
Forum Stats:
Groups: 3
Forums: 25
Topics: 7088
Posts: 31065
Member Stats:
Guest Posters: 49
Members: 34506
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —