Protect Sheets, Share Workbook, Protect Workbook

Basic Excel Tricks Logo New

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:

Excel Tricks

1. Protect Excel Sheets
  • Open an excel workbook > “Review” Tab > “Protect Sheet

 

Excel Tricks

Once you click on “Protect Sheet”, below window will appear:

Excel Tricks

So here is small glimpse of protecting excel sheet:

Excel Tricks

 

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

Excel Tricks

 

Below window will appear on your screen. So there are two tabs at the top:

1. Editing

Excel Tricks

2. Advanced

Excel Tricks

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

Excel Tricks

Hope you like this article. You may comment here, if you have any doubts. We are here to help you 🙂

Author:
Excelsirji.com was started with the thought of making people experience easy while working with Excel, data analytics, vba, automations etc.

Leave a Reply

avatar