Protect Sheets, Share Workbook, Protect Workbook
Creating beautiful and professional dashboards, projects always lead you to success however there are places when you wanted to protect your dashboards, sheets, cells to prevent users to make unnecessary editing because it can change calculations, sheets and sometimes, finish the essence of the project
So here we are talking about few features which can protect your excel sheets, projects, dashboards etc. Let’s have a look:
1. Protect Excel Sheets
- Open an excel workbook > “Review” Tab > “Protect Sheet”
Once you click on “Protect Sheet”, below window will appear:
So here is small glimpse of protecting excel sheet:
2. Share Your Excel Sheet with Other Users
Whenever two users want to work on one excel sheet at the same time, we use “Share Workbooks” option. This feature is amazing and allow multiple users to work on it at the same time:
- Open an excel workbook > “Review” Tab > Click on “Share Workbook”
Below window will appear on your screen. So there are two tabs at the top:
1. Editing
2. Advanced
Note: Few things to remember while using this “Shared Workbook” Option:
- “Shared Workbook” option cannot be used when you have “Tables” or “XML Maps” & “Data Connection” activated in your workbook
- “Protect Sheet” option should be activated before sharing the workbook else you will not be able to “Protect Sheets”
- There are multiple options which cannot be used in “Sharing Workbook” option like “Merge & Centre”, “No Shapes, Data Objects, Charts, Pictures etc.” can be inserted while workbook is in “Shared Workbook” mode
3. Protect Workbook
When you are tracking changes, it might be possible that people may delete the changes being done in the sheet however “Protect Workbook” helps to prevent users to turning off the changes. It just help to save the “Track Changes” data
Hope you like this article. You may comment here, if you have any doubts. We are here to help you 🙂
