how to share excel workbook in office 365

These errors might unshare the shared workbook with users. In this article, we address some of the solutions to this problem. We can also unshare and remove particular users from the shared workbook.You might get unexpected errors on a shared workbook, such as the “unreadable content”, or “ is locking the document” errors. Un-Share & Remove Users From Shared Workbooks “Protect Shared Workbook” means we are not allowing the user the option of change tracking of the shared workbook.“Protect Sheet” is protecting the worksheet, not the workbook.Below are the differences between these two: read more” and “Protect Shared Workbook.” Do not get confused with these two options. We can see two types of protection with excel, i.e., “ Protect Sheet in Excel Protect Sheet In Excel When we don't want any other user to make changes to our worksheet, we can use the Protect worksheet feature in Excel. However, it is always good to enter the password and share the workbook to control the changes. Step 4: Password is not the mandatory option.

Under “Password (optional),” we must insert the password as per wish and remember it! Step 3: Once we click on the “Protect and Share Workbook (Legacy),” we can see below the dialog box.Step 2: Next to “Share Workbook,” we have the “Protect and Share Workbook (Legacy)” option.Step 1: We must first go to the “Review” tab.To check users’ changes and have control, we must follow the below steps. The reason behind this is some settings in Excel.įollow the below steps to change settings. When we choose the option “Share Workbook,” it often shows the error message. After that, we can send the workbook’s stored link to the concerned person.Then, we must send the link or give the user ID password. After all the settings we have done in the above window, we must upload the file to a network location like Dropbox from where they can access the workbook.Under the “Advanced” tab, we can “Track Changes,” “Update Changes,” “Conflicting changes between users,” etc. Under the “Editing” tab, that was the only option we had.Next, select the checkbox “Use the old shared workbooks feature instead of the new co-authoring experience.” Below the window, we have two tabs, “Editing” and “Advanced,” under the “Editing” option.

As soon as we click on the “Share Workbook (Legacy),” it will show us the below dialog box.

Then, we must go to the “Review” tab and click on the “Share Workbook (Legacy)” option in Excel in that workbook.First, we need to decide which workbook we want to share, so open that Excel workbook first.Follow the below steps to learn about this option.

How to share excel workbook in office 365