How to Lock the Workbook but Not the Slicer in Excel

How do you lock the workbook but not the Slicer? You can easily lock the workbook but not the Slicer in Excel with this tutorial.

This is a handy trick so that you can still let your users to continue interacting with the slicer!

------------

👨‍🏫 MyExcelOnline Academy Online Excel Courses 👇
1,000 Microsoft Excel video training tutorials & support covering Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams & MORE...

🔥 OUR BEST EXCEL RESOURCES 🔥

------------

Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP!

If you enjoyed the video, please give a thumbs up, comment, share.

Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :)

Cheers,

JOHN MICHALOUDIS
Chief Inspirational Officer & Microsoft MVP

❤️ Let’s connect on social ❤️

#MyExcelOnline

[wayneedmondson]

Hi John.. great tip thanks. Also, like that tip of selecting one object and then CTRL+A to select all the other objects on the sheet.. will remember that one. Thanks for sharing these. Thumbs up!

[paraskatoch]

Excellent video. Thank you for sharing

[ultimatefinster]

Thanks for the video! In the current situation, people can still delete the slicer, however. Do you know if it's possible to let others use the slicer and make it impossible for them to delete it at the same time?

[tmb]

does this not work on newer versions of excel? I am pretty sure I have followed the steps exactly and every time the sheet will protect the pivot but still allow both to be filtered. I dont want the pivot to be filtered, only the slicers. any advice is appreciated. thanks

[devhaldar]

Please suggest how to unlock grouping while sheet is protected

[martinargimon]

hi i enjoyed your video, although i have locked the sheet and all the good things that u told us, I can still 'click' on the slicer itself and move it around ( even though I have disabled the 'move and size' property as well. Any ideas, please ?

[cmlosaria]

Hi for some reason, my slicers are still not useable after doing your steps.
Prompt message is "You can't use filters on this protected sheet. To remove protection, click the Unprotect Sheet button on the Review Tab"

Edit: Figured out the problem: I have enabled automatic protect of worksheets so I can run some Macros properly. Now I have to figure out that part.

[arid]

I was thinking to share (sharepoint)my dashboard and now I am not all concerned

[kabax]

It did not work for me. I can't use the slicers even though I unlocked them.