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
- 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.
- 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.
- Click OneDrive. It's a save location on this page.
- 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.
- 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.
- Click the Share tab. It's on the far-right side of the Excel toolbar that's near the top of the page.
- Right-click (or two-finger click) a user. Doing so will invoke a drop-down menu.
- 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.
- Click the Review tab. It's an option in the toolbar at the top of the Excel window.
- Click Share Workbook. This option is in the "Changes" section of the Review tab.
- 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.
- Click OK. Doing so will completely unshare your document and remove any users not manually removed by you.
Method 2 of 3:
On iPhone
- 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.
- 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.
- Tap OneDrive - Personal. It should be the top option on this page.
- If you don't see OneDrive - Personal here, tap Open again.
- 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.
- Tap the person-shaped icon. It's in the top-right corner of the screen. Doing this will open the "Share" page.
- 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.
- Tap a user's name. Anyone listed on this page (other than you) is someone with whom the document is shared.
- Tap Remove. Doing so will take your selected user off of the "Share" list.
- 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
- 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.
- 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.
- Tap OneDrive - Personal. This will open the OneDrive save location.
- 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.
- 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.
- Tap Manage. This option is near the top of the drop-down menu.
- Tap ⋮. It's to the right of a user's name.
- Tap Stop sharing. Doing so will remove your selected user from the "share" list.
- 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.
4 ★ | 35 Vote
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
Maybe you are interested
Video: Close-up of the destructive power of a 12th-century catapult
Review of TP-Link Tapo C120 smart camera: Strong security, affordable price
What is Network TAP? How does it help secure the system?
Poppy Playtime Chapter 2: How to find and locate all VHS tapes
Poppy Playtime Chapter 2: A guide to collecting VHS figurines and tapes
How to turn on dark mode by tapping on the back of iPhone