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.
Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2019 For Dummies today!
You can spend a lot of time getting your workbook to look "just right." Wouldn't it be great if Excel was able to ...
Discover MoreWhen you save a workbook, you have the opportunity to save a thumbnail image that can be displayed within Windows. Here's ...
Discover MoreIf you are afraid of messing up a workbook, consider doing your work on a clone of the workbook. Excel provides an easy ...
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