How To Turn Off Workbook Sharing In Excel

one

Open Excel. It'south a green app with a white "X" on information technology. To open up a shared document that you wish to unshare, y'all'll need to load the document from OneDrive.
2
Click Open up Other Workbooks . You should see it on the left-hand side of the page.
- If you've recently opened the document, it volition announced on the left side of the page; only click the version of the document that has "OneDrive" written below it.
Advertizing
three

Click OneDrive . Information technology's a salve location on this page.
4
Click the document you wish to unshare. Doing so will open it in Excel.
- Y'all may need to click through some folders to navigate to information technology showtime depending on where in OneDrive the file is stored.
5

Brand sure you've opened a shared certificate. If the name of the document at the summit of the Excel window has "[Shared]" to the right of it, it is currently existence shared.
6

Click the Share tab. It's on the far-correct side of the Excel toolbar that's well-nigh the top of the page.
7

Right-click (or two-finger click) a user. Doing so will invoke a drop-down carte.
viii
Click Remove User . This process will remove your selected user from the document'south sharing list.
- You'll repeat this process for each user in this department.
nine

Click the Review tab. Information technology's an choice in the toolbar at the meridian of the Excel window.
10

Click Share Workbook . This option is in the "Changes" department of the Review tab.
11

Uncheck the box at the top of the window. This box is next to the "Let changes past more than than one user at the same time" section.
12

Click OK . Doing and so volition completely unshare your document and remove any users not manually removed by you.

Advert

ane
Open Excel. It's a green app with a white "X" on it. If you're logged into your Microsoft account, doing so volition open the last tab you had open.
- If y'all aren't logged in, tap Sign in when prompted and enter your Microsoft account electronic mail address and countersign, then tap Sign in followed by Kickoff using Excel.
2
Tap the Open tab. Information technology'due south in the bottom-right corner of the screen.
- If Excel opens to a document, starting time tap the "Dorsum" push in the top-left corner of the screen.
3
Tap OneDrive - Personal . Information technology should be the height option on this page.
- If you lot don't see OneDrive - Personal here, tap Open up again.
4
Tap the shared certificate. Doing so will open information technology.
- You may have to tap through some folders to get to the certificate if you stored it anywhere other than your OneDrive'south dwelling page.
5

Tap the person-shaped icon. It'south in the top-right corner of the screen. Doing this volition open the "Share" page.
6
Tap Shared With . This option is near the center of the page.
- You will have to expect for a moment before this option appears, peculiarly if you're using a dull Internet connection.
vii

Tap a user's proper noun. Anyone listed on this page (other than you) is someone with whom the document is shared.
8

Tap Remove . Doing and so will have your selected user off of the "Share" list.
nine

Repeat the removal process for all users. After removing all users from the "Share" folio, your Excel document volition no longer be shared.

Advertisement

1
Open Excel. It'south a green app with a white "Ten" on it. If yous're logged into your Microsoft account, doing so will open up the final tab yous 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.
2
Tap Open other workbooks . It's in the lesser-left corner of the screen.
- If Excel opened to a document, kickoff tap File in the tiptop-left corner of the screen, so tap Open instead of Open other workbooks.
3

Tap OneDrive - Personal . This will open the OneDrive save location.
4
Tap the document you wish to unshare. Doing so volition open it in Excel.
- Depending on where in OneDrive the document resides, you lot may have to tap through some folders to open it.
5
Tap the "Share" icon. Information technology's the person-shaped button at the top of the screen. Doing so will prompt a drop-down carte.
- Don't tap the person-shaped icon in the far-right corner of the screen--that's your profile button.
half-dozen

Tap Manage . This pick is well-nigh the elevation of the drop-downwardly carte.
7

Tap ⋮ . It'due south to the correct of a user's name.
8

Tap Terminate sharing . Doing so will remove your selected user from the "share" list.
9

Stop sharing the document with any other users. After yous've uninvited all users from the certificate, the document volition no longer be shared with anyone.

Ad

Add New Question

Question

If I unshare a workbook to copy a canvass, can I then re-share the workbook?

Yes! You lot tin can share any Excel document as many times every bit you like.

Ask a Question

200 characters left

Include your email address to become a message when this question is answered.

Submit

Advertizement

To access documents in OneDrive on iPhone or Android, you'll need to have installed (and signed into) the OneDrive app.

In some cases, signing into the Android version of Excel will lock the Excel workbook unless you accept an Office 365 subscription. To remedy this upshot, merely sign out and then sign back in.

Advertizement