Asked by: Abdenasser Haynk
technology and computing shareware and freeware

How do I Unshare a workbook in Excel 2010?

Last Updated: 31st July, 2021

18
You can turn off sharing by following thesesteps:
  1. Display the Review tab of the ribbon.
  2. Click the Share Workbook tool, in the Changesgroup.Excel displays the Share Workbook dialogbox.
  3. Clear the Allow Changes check box.
  4. Click on OK.

Click to see full answer.

Also, how do you Unshare a workbook in Excel?

Open Excel.

  • Click Open Other Workbooks. You should see it on theleft-handside of the page.
  • Click OneDrive.
  • Click the document you wish to unshare.
  • Make sure you've opened a shared document.
  • Click the Share tab.
  • Right-click (or two-finger click) a user.
  • Click Remove User.
  • Similarly, how do I share an Excel workbook in 2019? Excel 2019 All-in-One For Dummies

    1. Open the workbook file you want to share in Excel 2019 andthenclick the Share button at the far right of the row withtheRibbon.
    2. Begin typing the name or e-mail address of the first personwithwhom you want to share the workbook in the text box withtheinsertion point.

    Similarly, how do I enable Unshare workbook in Excel 365?

    On the Review tab, in the Changes group, clickUnprotectShared Workbook. If you are prompted, enter thepassword,and then click OK. On the Review tab, in the Changesgroup, clickShare Workbook. On the Editing tab, clear theAllowchanges by more than one user check box.

    How do I undo an Unshare workbook?

    1. Cancel a shared workbook with Share Workbook feature.
    2. Open the workbook that you want to unshare, and thenclickReview > Share Workbook, see screenshot:
    3. In the b dialog box, uncheck the Allow changes by more thanoneuser at the same time option under the Editing tab,seescreenshot:

    Related Question Answers

    Munawar Ripley

    Professional

    How do I turn on workbook sharing in Excel 2016?

    With the workbook open, perform the following steps toshareit:
    1. On the Review tab, in the Changes group, click theShareWorkbook button.
    2. The Share Workbook dialog box will appear, and you selecttheAllow changes by more than one user at the same time.

    Judy Swietank

    Professional

    Can't Unshare workbook Excel 2016?

    Thereafter, in the shared workbook, go totheReview tab and under the Changes group, clickShareWorkbook. Clear the 'Allow changes by more than oneuser atthe same time' option. This also allows workbookmergingcheck box. For some reason, if you find the checkbox isnotvisible, unprotect the workbook.

    Soumiya Aspe├žada

    Explainer

    What is the advantage of sharing a workbook?

    An advantage of sharing spreadsheets meansthatyou can encourage employee collaboration. Onespreadsheetshared among several employees cuts down onmultiple files,which can contribute to information being lostoroverwritten.

    Guangming Mugarre

    Explainer

    How do you create a shared Excel file?

    Set up a shared workbook
    1. Click the Review tab.
    2. Click Share Workbook in the Changes group.
    3. On the Editing tab, click to select the Allow changes bymorethan one user at the same time.
    4. In the Save As dialog box, save the shared workbook on anetworklocation where other users can gain access to it.

    Gueye Mikhailjuk

    Pundit

    What is shared workbook in Excel?

    Share Workbooks
    If you share a workbook, you can work withotherpeople on the same workbook at the same time.Theworkbook should be saved to a network location whereotherpeople can open it. You can keep track of the changes otherpeoplemake and accept or reject those changes.

    Rozica Porres

    Pundit

    How do I turn off Protected View in Excel 2016?

    These steps can be applied for Excel 2010, 2013and2016.
    1. Click File > Options.
    2. Click Trust Center > Trust Center Settings >ProtectedView.
    3. Uncheck Enable Protected View for files originating fromtheinternet.

    Aleksandr Gojenola

    Pundit

    Can multiple users work on the same Excel file?

    Use Excel with MultipleUsersSimultaneously
    You can edit the same Excel filewithmultiple users through a feature called co-authoring.Thisfeature lets multiple people make changes in adocumentstored on a remote, so-called cloud server with theiractionshighlighted in different colors. Then, click EditinExcel.

    Dawood Amesti

    Pundit

    How do I share an Excel 2010 workbook?

    Instructions:
    1. Start the Microsoft® Excel 2010 application.
    2. Open the file you would like to share, or create anewfile.
    3. Switch to the “Review” tab.
    4. Click on the “Share Workbook” icon.
    5. Check the “Allow changes by more than one user at thesametime”.
    6. Click on the “OK” button.

    Yanetsy Lebowitz

    Pundit

    How do I share an Excel 2013 workbook?

    How to Share Excel 2013 Files
    1. Open the workbook to be shared and then make anylast-minuteedits to the file, especially those that are notsupported in ashared workbook.
    2. Choose File→Save As or press Alt+FA.
    3. Click the Share Workbook command button on the Review tab oftheRibbon or press Alt+RW.

    Jahel Scheidecker

    Teacher

    How do I make an Excel file read only for other users?

    Save as read only
    1. Click the Microsoft Office Button , and then click Save orSaveAs if you have previously saved the document.
    2. Click Tools.
    3. Click General Options.
    4. Click the Read-only recommended check box.
    5. Click OK.
    6. Save the document.

    Rosmery Esteba

    Teacher

    How do I create a shared folder?

    Here's how to share a folder on yourWindowsmachine:
    1. Locate the folder you want to share and right click onit..
    2. Choose "Share with" and then select "Specific People".
    3. A sharing panel will appear with the option to share withanyusers on the computer or your homegroup.
    4. After making your selection, click Share.

    Lohitzune Zmugg

    Teacher

    How do I save an Excel file?

    Save a file in the Excel 2007 file format
    1. Open the workbook that you want to save as an Excel2007workbook.
    2. Click the Microsoft Office Button , and then click SaveAs.
    3. In the File name box, accept the suggested name or type anewname for the workbook.
    4. In the Save as type list, do one of the following:
    5. Click Save.

    Umair Feranandes

    Beginner

    How do I enable Unshare workbook in Excel?

    On the Review tab, in the Changes group, clickUnprotectShared Workbook. If you are prompted, enter thepassword,and then click OK. On the Review tab, in the Changesgroup, clickShare Workbook. On the Editing tab, clear theAllowchanges by more than one user check box.

    Melecio Leiba

    Beginner

    How do I turn on Legacy sharing in Excel?

    Click the Share Workbook (Legacy) buttoneitherfrom the Review tab or either from the Quick Access Toolbar.Go toform and check the option Use the old sharedworkbooksfeature instead of the new co-authoring experience andclickOK.

    Weiwei Zannier

    Beginner

    How do you delete hidden sheets in Excel?

    Go to the ribbon, and click Enterprise>Worksheet Tools > Delete All HiddenSheets,see screenshot: 2. Then a prompt box pops out to remindyou if youreally want to delete allhiddenworksheets.

    Graciela Vichur

    Beginner

    How do I share a workbook in Excel 2016?

    How to share an Excel file
    1. On the Review tab, in the Changes group, click theShareWorkbook button.
    2. The Share Workbook dialog box will appear, and you selecttheAllow changes by more than one user at the same time.
    3. Optionally, switch to the Advanced tab, select thedesiredsettings for tracking changes, and click OK.

    Targelia O leary

    Beginner

    Can I track changes in Excel?

    Enabling the Track Changes inExcelFeature
    Go to the Review tab. In the Changes group,clickon the Track Changes option and selectHighlightChanges. In the Highlight Changes dialogbox, checkthe option – 'Track changes while editing.This alsoshares your workbook'.

    Ouarda Avraamov

    Beginner

    How do I track changes in Excel 2016?

    To turn on Track Changes:
    1. From the Review tab, click the Track Changes command,thenselect Highlight Changes from the drop-down menu.
    2. The Highlight Changes dialog box will appear.
    3. If prompted, click OK to allow Excel to save yourworkbook.
    4. Track Changes will be turned on.