Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Turning Off Sharing.
At some point you may want to turn off workbook sharing in Excel. For instance, when the end of the development period for the workbook has been reached, you will want to turn off sharing and come up with your final version of the workbook.
You can turn off sharing by following these steps:
When you turn off sharing and click on the OK button, Excel displays a warning that what you are doing may have consequences for other users. Provided there are no other users accessing the workbook, you should go ahead and click on Yes. If there are other users (shown back in the Share Workbook dialog box), you may want to ask them to save their changes and close the workbook before proceeding.
If you are using later versions of Excel, such as Excel 2019 or Excel in Office 365, you will notice that the buttons related to the Shared Workbook feature no longer exist. Microsoft has introduced the concept of Co-Authoring instead. The following Microsoft Office support article explains how you can still use the Shared Workbook feature with newer versions of Word:
https://support.office.com/en-us/article/what-happened-to-shared-workbooks-150fc205-990a-4763-82f1-6c259303fe05
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (8487) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. You can find a version of this tip for the older menu interface of Excel here: Turning Off Sharing.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
Workbooks can get rather large rather quickly. If you think your workbook has gotten too big too fast, here are some ...
Discover MoreIf you have two workbooks that each have the same name, opening them at the same time in Excel could cause some problems. ...
Discover MoreNot satisfied with the way that default workbooks and worksheets look in Excel? You can easily create your own defaults ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2020-08-26 03:29:57
Richard Curtis
Who is allowed to turn off sharing? Is it only the creator or can anyone do it?
2020-08-11 22:07:25
Peter
very helpful, thanks
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2021 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: 
Comments