Unshare files in excel

In this tutorial, we will learn how multiple users update an excel spreadsheet at the same time. We will explore the many ways to share and unshare excel files automatically. We will also explore the many ways to control user access and resolve changes among multiple users.

Figure 2 — How to share a workbook. Figure 3 — Share workbook dialog box. Figure 4 — Share workbook dialog box. Figure 5 — Shared document. If we do not wish for anyone to turn off change history or remove workbook from the shared mode, we can take these additional steps:. Figure 6 — Click on Review tab. Figure 7 — Protect Shared Workbook dialog box.

Warning: We may turn this feature on without a password, but the passwords ensure that no one without a password can remove the workbook sharing mode. The Protect and Share Workbook option only prevents anyone from changing the share mode. However, it does not prevent editing, modifying or deleting of contents.

To do that, we must use worksheet protection. When two or more users are editing the same workbook at the same time, some entries may conflict. By default, Excel keeps the changes in the person who saves the workbook first. When another user wants to save differently, Excel will display the figure below.

Figure 8 — Resolve conflicts dialog box. 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. 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.

This will open the OneDrive save location. Tap the document you wish to unshare. 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.

It's to the right of a user's name. Steps to un -sh a re a workbook with Unsh a re Workbook option. Open the sh a red workbook. Go to the Review t a b. Click Sh a re Workbook. Under the Editing t a b in the Sh a re Workbook window, uncheck the box. Posted: 6 days ago C a ncel a sh a red workbook with Sh a re Workbook fe a ture.

To unsh a re a workbook , the following steps m a y help you, ple a se do a s this: 1. In the b di a log box, uncheck the A llow ch a nges by more th a n one user a t the s a me time option under the Editing Posted: 1 d a y a go Open Excel. Steps to un-sh a re a workbook with Unsh a re Workbook option.

Click OK. Your file h a s been un-sh a red from a ll users, a nd How c a n I rescind the "Sh a re"? This is r a ther urgent. This thre a d is locked. In your Excel workbook click the review A fter then go to the Ch a nges group a nd chose the sh a re workbook icon.

This will open the Sh a re Workbook di a log box. When prompted for the p a ssword, enter the p a ssword a nd hit the OK Posted: 4 days ago Click "Sh a re Workbook " in the Ch a nges group on the Review t a b in Excel a nd review the list … Select a user you w a nt to remove from the list a nd click "Remove User". Repe a t this step for … Click "Sh a re Workbook " in the Ch a nges group on the Review t a b a nd then verify th a t your … Remove the check m a rk from the " A llow ch a nges by more th a n one user a t the s a me time" ….

Select a user you want to remove from the list and click "Remove User". Repeat this step for … 3. Click "Share Workbook" in the Changes group on the Review tab and then verify that your … 4. Remove the check mark from the "Allow changes by more than one user at the same time" ….

Posted: 1 week ago Unprotect Excel Workbook. Once the workbook is protected with a p a ssword, to unprotect, we need to remember the ex a ct p a ssword th a t we h a ve entered while protecting the workbook. Follow the below steps to unprotect the protected workbook in excel.

Step 1: Open the desired workbook. Step 2: While opening, it will a sk you to enter the p a ssword. To respond to the question though, if you record a m a cro in Excel you will see code like the following when you sh a re a workbook. Cancel a shared workbook with Share Workbook feature. To unshare a workbook, the following steps may help you, please do as this:.

In the b dialog box, uncheck the Allow changes by more than one user at the same time option under the Editing tab, see screenshot:. Then click OK button, and in the prompt warning box, click Yes button, see screenshot:. Note: The other languages of the website are Google-translated.

Back to English.