How to Unshare an Excel Workbook
This wikiHow teaches you how to stop sharing a Microsoft Excel document on desktop, iPhone, and Android platforms. 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...
Method 1 of 3:
On Desktop
-
Picture 1 of How to Unshare an Excel Workbook 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. -
Picture 2 of How to Unshare an Excel Workbook 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.
-
Picture 3 of How to Unshare an Excel Workbook Click OneDrive. It's a save location on this page. -
Picture 4 of How to Unshare an Excel Workbook 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.
-
Picture 5 of How to Unshare an Excel Workbook 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. -
Picture 6 of How to Unshare an Excel Workbook Click the Share tab. It's on the far-right side of the Excel toolbar that's near the top of the page. -
Picture 7 of How to Unshare an Excel Workbook Right-click (or two-finger click) a user. Doing so will invoke a drop-down menu. -
Picture 8 of How to Unshare an Excel Workbook 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.
-
Picture 9 of How to Unshare an Excel Workbook Click the Review tab. It's an option in the toolbar at the top of the Excel window. -
Picture 10 of How to Unshare an Excel Workbook Click Share Workbook. This option is in the "Changes" section of the Review tab. -
Picture 11 of How to Unshare an Excel Workbook 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. -
Picture 12 of How to Unshare an Excel Workbook Click OK. Doing so will completely unshare your document and remove any users not manually removed by you.
Method 2 of 3:
On iPhone
-
Picture 13 of How to Unshare an Excel Workbook 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.
-
Picture 14 of How to Unshare an Excel Workbook 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.
-
Picture 15 of How to Unshare an Excel Workbook Tap OneDrive - Personal. It should be the top option on this page.- If you don't see OneDrive - Personal here, tap Open again.
-
Picture 16 of How to Unshare an Excel Workbook 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.
-
Picture 17 of How to Unshare an Excel Workbook Tap the person-shaped icon. It's in the top-right corner of the screen. Doing this will open the "Share" page. -
Picture 18 of How to Unshare an Excel Workbook 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.
-
Picture 19 of How to Unshare an Excel Workbook Tap a user's name. Anyone listed on this page (other than you) is someone with whom the document is shared. -
Picture 20 of How to Unshare an Excel Workbook Tap Remove. Doing so will take your selected user off of the "Share" list. -
Picture 21 of How to Unshare an Excel Workbook Repeat the removal process for all users. After removing all users from the "Share" page, your Excel document will no longer be shared.
Method 3 of 3:
On Android
-
Picture 22 of How to Unshare an Excel Workbook 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.
-
Picture 23 of How to Unshare an Excel Workbook 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.
-
Picture 24 of How to Unshare an Excel Workbook Tap OneDrive - Personal. This will open the OneDrive save location. -
Picture 25 of How to Unshare an Excel Workbook 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.
-
Picture 26 of How to Unshare an Excel Workbook 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.
-
Picture 27 of How to Unshare an Excel Workbook Tap Manage. This option is near the top of the drop-down menu. -
Picture 28 of How to Unshare an Excel Workbook Tap ⋮. It's to the right of a user's name. -
Picture 29 of How to Unshare an Excel Workbook Tap Stop sharing. Doing so will remove your selected user from the "share" list. -
Picture 30 of How to Unshare an Excel Workbook 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.
Update 05 March 2020
You should read it
- How to Unhide Rows in Excel
- How to Add Up Columns in Excel
- How to Insert Hyperlinks in Microsoft Excel
- How to Make Tables Using Microsoft Excel
- How to Search for Words in Excel
- Instructions on how to automatically open a Workbook when you open Excel
- How to insert a Word document into an Excel file
- How to Edit a Document on iPhone
- MS Excel - Lesson 9: Protect spreadsheets and Excel files
- How to Convert Word to Excel
- Open an existing document in Word
- How to Truncate Text in Excel