How can i unshare a workbook

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 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. Note that in newer versions of Excel, the Share Workbook button has been hidden.

Here's how to unhide it. On the Editing tab, select the Allow changes by more than one user On the Advanced tab, select the options that you want to use for tracking and updating changes, and then click OK. If this is a new workbook, type a name in the File name box. Or, if this is an existing workbook, click OK to save the workbook. If the workbook contains links to other workbooks or documents, verify the links and update any links that are broken. When you're done, - Shared will appear at the top of the Excel window, next to the filename.

Please be aware that Shared Workbooks is an older method of sharing. Therefore, many items and actions are not supported when this method is used. The table below is only a partial list of features not supported. Before you disconnect users, make sure that they have completed their work on the workbook.

If you remove active users, any unsaved work of theirs will be lost. On the Editing tab, in the Who has this workbook open now list, review the names of users.

Select the name of the user who you want to disconnect, and then click Remove User. Please note that although this action disconnects the user from the workbook, it does not prevent that user from editing the workbook again. Before you turn off this feature, you might want to make a copy of the change history. First make sure that all other users have completed their work. Note that in newer versions of Excel, the Track Changes button has been hidden.

Select the List changes on a new sheet check box, and then click OK. Now you can either print the History worksheet, or you can copy the history and paste it into another workbook. On the Editing tab, make sure that you are the only person listed in the Who has this workbook open now list.

Clear the Allow changes by more than one user 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. 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.