As soon as the ultimate model of your Excel workbook or Microsoft 365’s model of Excel Workbook is full you may want to stop or turn off the workbook sharing in Excel to avert any undesirable adjustments. Nonetheless, earlier than stopping the sharing of a workbook, guarantee all the ultimate adjustments or additions have been accommodated as a result of any unsaved adjustments might be misplaced. The Change historical past will even be deleted, alongside. Right here’s how to go about it.
How do you turn off workbook sharing in Excel
First, copy the change historical past data. For this, click on ‘Track changes’ possibility seen underneath the Adjustments Group of Assessment tab.
Subsequent, hit the Spotlight Adjustments button. Within the When record, choose All and clear the Who and The place checkboxes.
Now, choose the Listing adjustments on a brand new sheet verify field, after which click on OK. Now, do the next
Copy the historical past to one other workbook. Choose the cells that you’d need to copy, swap to one other workbook, and place the copied knowledge. Thereafter, in the shared workbook, go to the Assessment tab, and underneath the Adjustments group, click on Share Workbook.
Clear the ‘Allow changes by more than one user at the same time’ possibility. This additionally permits the workbook merging verify field. For some motive, in case you discover the checkbox isn’t seen, unprotect the workbook. Now, to take away shared workbook safety, do the next:
Click on OK to shut the Share Workbook dialog field.
Change to the Assessment tab, in the Adjustments group, click on Unprotect Shared Workbook.
When prompted for the password, enter the password and hit the OK button.
Then, on the Assessment tab, in the Adjustments group, click on Share Workbook.
Thereafter, Within the Enhancing tab, clear the Permit adjustments by a couple of person on the identical time. This additionally permits the workbook merging verify field. When your permission for making adjustments in regards to the results on different customers is sought, click on Sure.
Why can’t I unshare my Excel workbook?
Though the Unshare Workbook possibility needs to be seen in the Assessment tab in Excel, there could possibly be instances when it could be grayed out. It occurs once you share a Workbook through the co-authoring possibility. In that case, you want to take away the entry manually from OneDrive. You need to use the web model of OneDrive or the desktop app to do the identical factor.
How do I stop others from enhancing my Excel Workbook?
So as to stop or forestall others from enhancing your Excel Workbook, you want to use the Unshare Workbook possibility. Yow will discover this feature in the Assessment tab after opening the Excel app. Alternatively, it’s also possible to do the identical factor utilizing the Take away entry possibility, which is out there solely once you open the OneDrive app in your desktop.
That’s it! Hope it helped.
