If you’re building any kind of Excel based dashboard or interactive report it’s probably going to include Pivot Tables and you’re probably going to need to apply filters to those Pivot Tables. That’s where Slicers come in useful.
But at the same time, you’re probably going to want to protect the Dashboard sheet. The problem is that when worksheet protection is enabled, the Slicer buttons stop working. In this video I’ll show you how to fix this problem.
🗒 Notes and Resources
Download a copy of the file used in this video: app.box.com/s/7kccxj6vv6tc74j...
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #slicers #dashboards #protection
Негізгі бет Excel: Slicer Buttons aren't Clickable. Here's the Fix!
Пікірлер: 10