How to Unshare an Excel Workbook on Desktop & Mobile

PDF download Download Article
Fast ways to stop sharing an Excel workbook on your computer or phone
PDF download Download Article

If you want to stop sharing an Excel file with others, there's an easy way to do it. The process differs slightly depending on whether you're using Excel's legacy shared workbook feature or Microsoft 365's newer co-authoring feature. This wikiHow guide teaches you how to stop sharing a Microsoft Excel workbook on desktop, iPhone, and Android platforms and includes helpful troubleshooting tips.

Quick Steps

  1. Click the Review tab.
  2. Click Share Workbook or the Share Workbook button.
  3. Remove the checkmark from "Allow changes by more than one user."
  4. Click OK .
Section 1 of 4:

Unsharing a Legacy Shared Excel Workbook (Desktop)

PDF download Download Article
  1. Microsoft recommends using the "co-authoring" feature of Microsoft 365 instead of sharing workbooks, as it ensures shared workbooks can be edited in Excel for Web. [1] If you still have an Excel file that you previously shared with others, use this method to unshare it.
  2. Advertisement
  3. You may see this option in the "Changes" section of the Review tab. If you don't see it (or it's grayed out), you can add it to the Quick Access Toolbar to restore the old Shared Workbook features to your newer version of Excel. After you follow these steps, you'll see a "Shared Workbook (Legacy)" option in the Quick Access Toolbar, and you need to click it to continue. [2]
    • Windows
      • Click the File menu and go to Options > Quick Access Toolbar .
      • Under "Choose commands," select All Commands .
      • Select Share Workbook (Legacy) and click Add .
      • Select Track Changes (Legacy) and click Add .
      • Select Protect Sharing (Legacy) and click Add .
      • Select Compare and Merge Workbooks and click Add .
      • Click OK .
    • Mac
      • Click the Excel menu and go to Preferences > Ribbon & Toolbar .
      • Click Quick Access Toolbar .
      • Click Review Tab under "Choose commands from."
      • Select Share Workbook (Legacy) and click the > to add it to the list.
      • Click Save .
  4. This box is next to the "Allow changes by more than one user at the same time" section.
    • If the checkbox isn't there or is grayed out, the workbook is protected. To unprotect it:
      • Close the Share Workbook window by clicking OK .
      • Click the Review tab and select Unprotect Shared Workbook .
      • If needed, enter the workbook's password to continue.
      • Click the Shared Workbook option again on the Quick Access Toolbar.
      • Remove the checkmark from the "Allow changes by more than one user" box. [3]
  5. Doing so will completely unshare your document and remove any users not manually removed by you.
    6. Advertisement
Section 2 of 4:

Unsharing a Co-authored Excel Workbook (Desktop)

PDF download Download Article
  1. Microsoft no longer recommends using the older "Shared Workbook" feature for collaboration in Excel. If you subscribe to Microsoft 365, have the latest version of Excel installed on your PC or Mac, and have been collaborating on a shared workbook with someone else, you're likely using the "co-authoring" feature instead of the "Shared Workbook" feature. In this case, to stop sharing the file, you'll need to remove access from the people you're collaborating with.
  2. If you downloaded the workbook from OneDrive or Sharepoint, you may see a yellow bar at the top of the file that says "Protected View." To make changes, click Enable Editing on the bar to edit the workbook.
  3. It's at the top-right corner of Excel.
  4. It'll be near the bottom of the menu.
  5. If you are sharing the workbook with specific people or groups, you can remove access from their accounts to stop sharing the workbook.
    • On the People tab, click the menu next to each person's name, click Direct Access , click the menu, and select Remove Direct Access .
    • On the Groups tab, do the same to remove access for any groups.
  6. If you've generated a link for this workbook, it'll appear here.
  7. This deletes the shared workbook link, making it inaccessible to anyone accessing it over the web. Once you've completed all these steps, the Excel workbook will no longer be shared.
    8. Advertisement
Section 3 of 4:

Unsharing a Co-authored Excel Workbook (Mobile)

PDF download Download Article
  1. If you want to stop sharing an Excel workbook you're co-authoring with others on your Android, iPhone, or iPad, you can do so using the mobile app.
    • If you aren't logged into your Microsoft 365 account, tap Sign in to log in now.
  2. It looks like a circle spread out to two others and is in the top right corner of your screen. [4]
  3. This displays a list of people you're sharing the Excel file with.
  4. Under "Manage Permissions," you'll see all users with access to this workbook and the type of permission they have to edit it. To stop sharing, tap the person's current permissions (e.g., "Can Edit"), then tap Remove or Stop Sharing , depending on your platform.
  5. After removing all users from the "Share" page, your Excel document will no longer be shared.
    6. Advertisement
Section 4 of 4:

Troubleshooting

PDF download Download Article
  1. Because Co-authoring is replacing the older Shared Workbook feature, you won't be able to click the Shared Workbook button on the Review toolbar in Excel unless you add the Legacy version of this feature to the Quick Access Toolbar. Use these steps to add a Shared Workbook (Legacy) button to the toolbar so you can unshare the workbook.
  2. If you can't select a user to stop sharing with or there is no option to delete or remove their access, the person likely has the workbook open. Wait until they're finished and try again.
    • If your organization uses SharePoint and you're an admin, you can manually close the file for them through the document library. [5]
  3. Make sure you are signed in to an account that's subscribed to Microsoft 365 and that you have permission to edit the workbook.
    4. Advertisement

Community Q&A

Search
Add New Question
  • Question
    If I unshare a workbook to copy a sheet, can I then re-share the workbook?
    Community Answer
    Yep! You can share any Excel document as many times as you like.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 0 Helpful 2
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Group and Outline Excel Data: Easily Collapse Rows of Info
      How to
      Password Protect a Microsoft Excel Spreadsheet
      How to
      Create a User Defined Function in Excel
      3 Simple Ways to Edit Data in MS Excel
      How to
      Write a Simple Macro in Microsoft Excel
      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Unprotect an Excel Sheet
      How to
      Unhide All Rows and Columns in Microsoft Excel
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Create a Graph in Excel
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/office/about-the-shared-workbook-feature-49b833c0-873b-48d8-8bf2-c1c59a628534#OfficeVersion=Windows
      2. ↑ https://support.microsoft.com/en-us/office/what-happened-to-shared-workbooks-150fc205-990a-4763-82f1-6c259303fe05#ID0EBBF=Newer_Windows_versions
      3. ↑ https://support.microsoft.com/en-us/office/about-the-shared-workbook-feature-49b833c0-873b-48d8-8bf2-c1c59a628534#OfficeVersion=Windows
      4. ↑ https://support.microsoft.com/en-us/office/collaborate-on-excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104#PickTab=iOS
      5. ↑ https://answers.microsoft.com/en-us/msoffice/forum/all/is-it-possible-to-boot-someone-out-of-a-shared/46fca37b-6c5b-47e6-bfb2-2968ae545f08

      About This Article

      In other languages
      Thanks to all authors for creating a page that has been read 702,622 times.

      Reader Success Stories

      • Justin Irlbeck

        Jul 13, 2017

        "Being a shared document was limiting the functions I could use in Excel. This story helped me remove this so I ..." more
        Rated this article:
      More reader stories Hide reader stories
      Share your story

      Is this article up to date?

      Advertisement