Mynda, the fact that you've had this channel since 2010, and still you take time to "like" all 55 comments says a lot about you as a person. For this reason alone you have a new subscriber, fan, newsletter expertise

Another awesome tutorial by Mynda, you're absolutely an excel genius. Everyone who's watching should take advantage of this because not all instructor are rendering their service free of charge. Kudos!

I use protect sheets in most of my files but when ever I watch one of your videos I learn something new. This video did not disappoint either. Thanks for covering these little topics that we all think we know. Kudos to you.

Thank you so much for your videos. I like your approach, pace and expounding more on the topic.All your videos were helpful.Imagine watching one of your video every night before going to bed.Thank you a 1000 times.

Thanks for all the examples and explanations. Watching your videos has helped me to become proficient at excel dashboards. Your videos are clear, precise, informative and more importantly one can use your teaching right away. Congratulations!

Thanks Mynda. Glad you mentioned that Worksheet and Workbook protection available from the ribbon buttons is easy to bypass (it is). Also, just learned that you can now unhide more than one worksheet at a time directly from the Unhide dialog. Been waiting for that for years. Thanks for sharing :)) Thumbs up!!

Very nice. As always with proper pace so that even a beginner can understand.

Best video about protecting an awesome piece of work (the dashboard!). One and only tiny suggestion: hide columns from W to the last one (right) and row 36 to the last one (down), and that´s it! This "hiding columns step" I always do, to frame the area on the worksheet where the dashboard or report ...."lives & breathes..." 😝🤙 lastly good points on minute 2:00 and 2:45 for the steps in protecting the visual objects !

HI Mynda. Many Thanks for your quick tutorials , they are always very helpful and u are a superb teacher.. Thanks again ., all the best ! Martin (south africa)

Great video and very useful Mynda, thank you very much for sharing these insights!

Thank you so much for your videos! It has been great help! I always learn something new or the usages of a specific tool I´d heard before.

Great video! Is there any backend benefit/enhanced security by preventing any editing for the entire workbook upon initial entry (file -> passwords -> prevent editing = making it read-only) vs protecting/"locking" all sheets/ workbook from within the file itself (Review Tab -> Protect Workbook/Protect Sheet)? Other than differences in read-only versus locking from a frontend accessibility standpoint (still can unhide arrays in read-only for example), is it more advantageous to use both forms/"layering" of security, or will the locking-features from within a file be enough?

Thanks for the clear explanation 👍

Glad you reminded people that the password protection is not robust.

I have been looking for something like this for a long time. Thank you so much🙏🏼🙏🏼🙏🏼

Hi Mynda. Another Gold Standard tutorial. I have a workbook with a couple of slicers and a timeline but, when I try to disable resizing and moving, the tick box is greyed out.

Thank you so much. Well explained & easy to understand.

Well explained Mynda - Subscribed!

Great video! Very informative.

You are life saver! I learned a lot from your videos. Quick question, can you also lock the way your excel looks like when you send it as attachment? Like for example, when you hide the ribbons, formula bar, headings? And even some of the changes you made in advance option when not showing the horizontal and vertical bars and sheets? Thanks in advance! 😉

Thank you. You rescued me.

Thanks for all you do. I have a question. I know there is a way to make an Excel so that if someone sends it to another person, it will stop working. I have Excels that I sell & customers have to enter in current data. I understand how to unlock certain cells [so customers can enter current info] & lock others [so customers cannot edit or copy formulas], then protect the sheet. I also add copyright info in locked cells so that no one can resell it. But there is nothing stopping them from looking up a KZfaq video on how to remove that protectection. But I know others in my same niche who create Excels & somehow they protect that Excel from being emailed to anyone else. This is exactly what I need so that no one steals my work & resells it. It's been a huge problem. I come out with a new Excel product and after a month of sales, everyone has it. The customers in my community are very close & share information, so after one person buys it, they just send it to all of their friends. I know there is a way to do this, but all the people selling Excels in this niche are very close mouthed and DON'T share knowledge.

Hi Mynda!Great Tips,Unfortunately I Have To Use These Techniques In My Office...Thank You :)

As always, valuable and useful content !!! One of the problems I haven't found a solution anywhere is how to secure the "official" Excel table (ctrt + T) so that the user can edit the rows (add new, change or delete) but he/she is not allowed to change the table structure (headers, formats, adding or removing columns etc.).

Thanks Mynda. Keep up the great content

Very useful video. Thank you.

What could be better methods to add security features that can't be broken for protecting a workbook and sheet-level other than using the standard 'Protect Workbook' and 'Protect Sheet"? I was thinking along the lines of using VBA macros or other methods. Thanks for any suggestions!

Excelente Mynda! Muchas gracias!

Another great video Mynda. Unfortunately, it seems not work in my case, where the pivot tables don't refresh. In my file, I have pivot tables created from PowerPivot with tables loaded into data model from power query linked to external files. Can you confirm that I must use another strategy to protect the file but allow the updating of pivot tables?

Great tip! Thanks a lot!

Very Nice, thanks! I won't be able to change the Data Source for my Pivot Table if my Sheet is Protected. Right?

Thanks for this. How can I protect the sheet but still allow data groups to be expanded and collapsed?

Nice tips. I'll be using this in the future.

hiya is there an option, where i can leave all sheets visible to others, but have all sheets protected from editing ? Like the protect sheet option, but for 20 sheets on one go ?

Despite that, the right-click option is still active for the slicers even the worksheet is protected, so that unwanted changes can be made. How to disable the slicers right-click menu ?

I would like to know how to create different view in a same dashboard. One for manager view and one for employee view. When employees click the excel specific sheets should not be viewed. When managers click it all sheets should be viewed

Thk U so much for your incredible work! I'm a great fan! Can you post the link of the video wich contains the dashboard construction please? I'm trying to do something like you (seems) to have: a combobox filtering all the dashboard objets. I can not find it. Once again, congrats for your work!

I normally just make my workbooks read only, or an xlst, because I get fed up of unprotecting every time I need to make a change! I usually use a plus (changing to a minus on selection) icon to replicate the pivot chart +/- buttons using a macro. I find the standard ones a bit ugly and also leave the chart open to being moved, resized etc by a clumsy user.

Thank you for the video.. but the chart on top right is still movable.. I want my user to interact with the + & - signs but not drag and move it.. that's not happening.. tried the don't move option in formatting but doesn't work.. Do you have any other ways of doing it ? Thanks in advance!

Hey Mynda, Thanks for another very useful video :-) I have a question. Is there an option to disable resizing and moving of charts similar to slicers? I have drill down buttons on my chart and I want the users to interact with the charts. So, I would want to keep the charts unlocked but I would want to lock it for movement or resizing similar to slicers. Is this possible?

Very useful thanks

Is there any way to make it so that the user can use the +/- drill down buttons on the pivot chart, without it being so that they select the chart, the pull handles appear, and they're able to move the chart around if they're not careful? I'm desperately trying to figure out how to do this.. 😭

You are very successful 👏👏 Great video thanks for turkey

i cannot access the protection tab while using the online office 365, like when im on a chromebook, help !?

Mynda Hi, Problem is that we are able to use VBA for unprotecting worksheets or workbook. For example, if we locked a worksheet and send it our colleagues and then if anybody knows VBA editor, he/she can make it unprotect. So, is there any technique to protect sheets from users even if who knows VBA ? Thank you

I want to disable resizing and moving the timeline but I could not because it does not allow me to select under the position menu. Please help. Thanks

Thanks Mynda!

The exel tends to round off a big number to exponents and once it is saved even if someone try to convert it to number it will show zeros. What is the work around

I want user to allow using grouping and ungrouping. How to enable group and ungroup in a protected sheet without doing unprotect and password at all. I tried everything i knew please help

Hi mynda. Just a quick one. Do u share your reports with your clients via ‘Onedrive’?, and if so , I understand that U can either give them the right to view only or to edit. There is very little tutorials on hiw to share all our reports and sheets ‘on line’ and i would think that the ‘essence’ of the ‘on line’ version is to get more people to use this feature. I use it all the time , but tutorials in general do not regard this topic as essential. The whole world is shifting into ‘on line’ sharing and yet we see NOT much on ‘on line’ interface. Am i right or fantazising ?

Thanks very much my teacher!

How can I group/ungroup columns in a protected sheet?

thanks alot for this video....

This is great! However, my users are still able to right click on the slicers and make changes to the settings. I want users to be able to use the slicers without being able to right click on slicers. Does anyone know how to do that?

Fantastic! Thank you!

Thank you!

Im trying to lock certain rows and coloums but everytime I lock them, the whole shee gets locked. Somebody, help me. 😭

Thank you so much

would love to know how to protect 50 sheets at once.

Sorry, previous comment should have referred to the timeline only. Slicers were fine

Thank you very much :)

Thank you :)

Thanks!

Hola!!!