How to Unshare an Excel Workbook

Step-by-Step Guide

1. 1

   Step 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. , 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. , It's a save location on this page., 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. , If the name of the document at the top of the Excel window has "" to the right of it, it is currently being shared., It's on the far-right side of the Excel toolbar that's near the top of the page., Doing so will invoke a drop-down menu., This process will remove your selected user from the document's sharing list.
   
   You'll repeat this process for each user in this section. , It's an option in the toolbar at the top of the Excel window., This option is in the "Changes" section of the Review tab., This box is next to the "Allow changes by more than one user at the same time" section., Doing so will completely unshare your document and remove any users not manually removed by you.
2. 2

   Step 2: Click Open Other Workbooks.

3. 3

   Step 3: Click OneDrive.

4. 4

   Step 4: Click the document you wish to unshare.

5. 5

   Step 5: Make sure you've opened a shared document.

6. 6

   Step 6: Click the Share tab.

7. 7

   Step 7: Right-click (or two-finger click) a user.

8. 8

   Step 8: Click Remove User.

9. 9

   Step 9: Click the Review tab.

10. 10

    Step 10: Click Share Workbook.

11. 11

    Step 11: Uncheck the box at the top of the window.

12. 12

    Step 12: Click OK.

Detailed Guide

About the Author