Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and 2021. 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.
Written by Allen Wyatt (last updated February 22, 2024)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and 2021
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 2021. You can find a version of this tip for the older menu interface of Excel here: Turning Off Sharing.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
Workbooks can get rather large rather quickly. If you think your workbook has gotten too big too fast, here are some ...
Discover MoreExcel keeps track of a range of stats about each workbook you use. If you want to take a look at those stats, it's easy; ...
Discover MoreYou can create a default template for both your workbooks and worksheets. These should be placed in the XLSTART folder, ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2021-02-24 11:52:12
Protoss
Thank you Allen, saved the day for a co-worker
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 © 2025 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and 2021. 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