How to Unshare an Excel Workbook

This wikiHow teaches you how to stop sharing a Microsoft Excel document on desktop, iPhone, and Android platforms.

Method 1
Method 1 of 3:

On Desktop

  1. Image titled Unshare an Excel Workbook Step 1
    1
    Open Excel. It's a green app with a white "X" on it. To open a shared document that you wish to unshare, you'll need to load the document from OneDrive.
  2. Image titled Unshare an Excel Workbook Step 2
    2
    Click Open Other Workbooks. You should see it on the left-hand side of the page.
    • If you've recently opened the document, it will appear on the left side of the page; simply click the version of the document that has "OneDrive" written below it.
    Advertisement
  3. Image titled Unshare an Excel Workbook Step 3
    3
    Click OneDrive. It's a save location on this page.
  4. Image titled Unshare an Excel Workbook Step 4
    4
    Click the document you wish to unshare. Doing so will open it in Excel.
    • You may need to click through some folders to navigate to it first depending on where in OneDrive the file is stored.
  5. Image titled Unshare an Excel Workbook Step 5
    5
    Make sure you've opened a shared document. If the name of the document at the top of the Excel window has "[Shared]" to the right of it, it is currently being shared.
  6. Image titled Unshare an Excel Workbook Step 6
    6
    Click the Share tab. It's on the far-right side of the Excel toolbar that's near the top of the page.
  7. Image titled Unshare an Excel Workbook Step 7
    7
    Right-click (or two-finger click) a user. Doing so will invoke a drop-down menu.
  8. Image titled Unshare an Excel Workbook Step 8
    8
    Click Remove User. This process will remove your selected user from the document's sharing list.
    • You'll repeat this process for each user in this section.
  9. Image titled Unshare an Excel Workbook Step 9
    9
    Click the Review tab. It's an option in the toolbar at the top of the Excel window.
  10. Image titled Unshare an Excel Workbook Step 10
    10
    Click Share Workbook. This option is in the "Changes" section of the Review tab.
  11. Image titled Unshare an Excel Workbook Step 11
    11
    Uncheck the box at the top of the window. This box is next to the "Allow changes by more than one user at the same time" section.
  12. Image titled Unshare an Excel Workbook Step 12
    12
    Click OK. Doing so will completely unshare your document and remove any users not manually removed by you.
    13. Advertisement
Method 2
Method 2 of 3:

On iPhone

  1. Image titled Unshare an Excel Workbook Step 13
    1
    Open Excel. It's a green app with a white "X" on it. If you're logged into your Microsoft account, doing so will open the last tab you had open.
    • If you aren't logged in, tap Sign in when prompted and enter your Microsoft account email address and password, then tap Sign in followed by Start using Excel.
  2. Image titled Unshare an Excel Workbook Step 14
    2
    Tap the Open tab. It's in the bottom-right corner of the screen.
    • If Excel opens to a document, first tap the "Back" button in the top-left corner of the screen.
  3. Image titled Unshare an Excel Workbook Step 15
    3
    Tap OneDrive - Personal. It should be the top option on this page.
    • If you don't see OneDrive - Personal here, tap Open again.
  4. Image titled Unshare an Excel Workbook Step 16
    4
    Tap the shared document. Doing so will open it.
    • You may have to tap through some folders to get to the document if you stored it anywhere other than your OneDrive's home page.
  5. Image titled Unshare an Excel Workbook Step 17
    5
    Tap the person-shaped icon. It's in the top-right corner of the screen. Doing this will open the "Share" page.
  6. Image titled Unshare an Excel Workbook Step 18
    6
    Tap Shared With. This option is near the middle of the page.
    • You will have to wait for a moment before this option appears, especially if you're using a slow Internet connection.
  7. Image titled Unshare an Excel Workbook Step 19
    7
    Tap a user's name. Anyone listed on this page (other than you) is someone with whom the document is shared.
  8. Image titled Unshare an Excel Workbook Step 20
    8
    Tap Remove. Doing so will take your selected user off of the "Share" list.
  9. Image titled Unshare an Excel Workbook Step 21
    9
    Repeat the removal process for all users. After removing all users from the "Share" page, your Excel document will no longer be shared.
    10. Advertisement
Method 3
Method 3 of 3:

On Android

  1. Image titled Unshare an Excel Workbook Step 22
    1
    Open Excel. It's a green app with a white "X" on it. If you're logged into your Microsoft account, doing so will open the last tab you had open.
    • If you aren't logged in, tap Sign in when prompted and enter your Microsoft account email address and password, then tap Sign in followed by Start using Excel.
  2. Image titled Unshare an Excel Workbook Step 23
    2
    Tap Open other workbooks. It's in the bottom-left corner of the screen.
    • If Excel opened to a document, first tap File in the top-left corner of the screen, then tap Open instead of Open other workbooks.
  3. Image titled Unshare an Excel Workbook Step 24
    3
    Tap OneDrive - Personal. This will open the OneDrive save location.
  4. Image titled Unshare an Excel Workbook Step 25
    4
    Tap the document you wish to unshare. Doing so will open it in Excel.
    • Depending on where in OneDrive the document resides, you may have to tap through some folders to open it.
  5. Image titled Unshare an Excel Workbook Step 26
    5
    Tap the "Share" icon. It's the person-shaped button at the top of the screen. Doing so will prompt a drop-down menu.
    • Don't tap the person-shaped icon in the far-right corner of the screen--that's your profile button.
  6. Image titled Unshare an Excel Workbook Step 27
    6
    Tap Manage. This option is near the top of the drop-down menu.
  7. Image titled Unshare an Excel Workbook Step 28
    7
    Tap ⋮. It's to the right of a user's name.
  8. Image titled Unshare an Excel Workbook Step 29
    8
    Tap Stop sharing. Doing so will remove your selected user from the "share" list.
  9. Image titled Unshare an Excel Workbook Step 30
    9
    Stop sharing the document with any other users. After you've uninvited all users from the document, the document will no longer be shared with anyone.
    10. Advertisement

Community Q&A

  • Question
    If I unshare a workbook to copy a sheet, can I then re-share the workbook?
    Community Answer
    Community Answer
    Yep! You can share any Excel document as many times as you like.
Advertisement

Warnings

  • In some cases, signing into the Android version of Excel will lock the Excel workbook unless you have an Office 365 subscription. To remedy this issue, simply sign out and then sign back in.
    ⧼thumbs_response⧽
Advertisement

You Might Also Like

Group and Outline Excel DataHow to Group and Outline Excel Data: Easily Collapse Rows of Info
Password Protect an Excel Spreadsheet
How to
Password Protect an Excel Spreadsheet
Create a User Defined Function in Microsoft Excel
How to
Create a User Defined Function in Microsoft Excel
Edit Data in Microsoft Excel
How to
Edit Data in Microsoft Excel
Write a Simple Macro in Microsoft ExcelHow to Write a Simple Macro in Microsoft Excel
Make a Spreadsheet in Excel
How to
Make a Spreadsheet in Excel
Unprotect an Excel Sheet
How to
Unprotect an Excel Sheet
Create a Mortgage Calculator With Microsoft Excel
How to
Create a Mortgage Calculator With Microsoft Excel
Create a Graph in Excel
How to
Create a Graph in Excel
Create a Timeline in ExcelHow to Create a Timeline in Excel: SmartArt, Templates, and More
Change from Lowercase to Uppercase in Excel
How to
Change from Lowercase to Uppercase in Excel
How to
Unhide Rows in Excel
Insert Pictures in Excel That Automatically Size to Fit Cells
How to
Insert Pictures in Excel That Automatically Size to Fit Cells
Convert Excel to Word3 Easy Ways to Convert Microsoft Excel Data to Word
Advertisement

About This Article

Jack Lloyd
Written by:
Jack Lloyd
wikiHow Technology Writer
This article was co-authored by wikiHow staff writer, Jack Lloyd. Jack Lloyd is a Technology Writer and Editor for wikiHow. He has over two years of experience writing and editing technology-related articles. He is technology enthusiast and an English teacher. This article has been viewed 685,842 times.
How helpful is this?
Co-authors: 8
Updated: September 24, 2022
Views: 685,842
Categories: Microsoft Excel
Advertisement