How to stop or turn off Workbook Sharing in Excel 2016

Once the concluding version of your Excel 2016 workbook is consummate you lot mightiness desire to terminal or plough off the workbook sharing inwards Excel 2016 to avert whatsoever unwanted changes. However, earlier stopping the sharing of a workbook, ensure all the concluding changes or additions convey been accommodated, because whatsoever unsaved changes volition endure lost. The Change history volition too endure deleted, alongside. Here’s how to instruct about.

How create you lot plough off workbook sharing inwards Excel

First, re-create the modify history information. For this, click ‘Track changes’ selection visible nether changes Group of Review tab.

Next, hitting the Highlight Changes button. In the When list, choose All together with clear the Who together with Where depository fiscal establishment tally boxes.

Now, choose the List changes on a novel sail depository fiscal establishment tally box, together with thence click OK. Now, create the following

Copy the history to some other workbook. Select the cells that you lot would desire to copy, switch to some other workbook together with house the copied data. Thereafter, inwards the shared workbook, instruct to the Review tab together with nether the Changes group, click Share Workbook.

Clear the ‘Allow changes yesteryear to a greater extent than than 1 user at the same time’ option. This too allows workbook merging depository fiscal establishment tally box. For some reason, if you lot discovery the checkbox is non visible, unprotect the workbook. Now, to take shared workbook protection, create the following:

Click OK to closed the Share Workbook dialog box.

Switch to the Review tab, inwards the Changes group, click Unprotect Shared Workbook.

When prompted for the password, move inwards the password together with hitting the OK button.

Then, on the Review tab, inwards the Changes group, click Share Workbook.

Thereafter, In the Editing tab, clear the Allow changes yesteryear to a greater extent than than 1 user at the same time. This too allows workbook merging depository fiscal establishment tally box. When your permission for making changes virtually the effects on other users is sought, click Yes.

That’s it!

Source: https://www.thewindowsclub.com/

Share This :