How to Co-edit an Excel Workbooks with Multiple People

Date:2019-11-1 Author:Cordelia

Processing data with Excel is not always an independent work. Sometimes it may be unavoidable to co-edit a workbook with multiple people for collecting more complete information and reaching a higher efficiency. So how to make an Excel file editable for more than one users?

1. Open the file you want to share, switch to Review tab and you can find Share Workbook in Changes section.

How to Co-edit an Excel Workbooks with Multiple People

2. Check “Allow changes by more than one users at the same time. This also allows workbook merging.” in Editing tab.

How to Co-edit an Excel Workbooks with Multiple People

3. You can also click Advanced for further settings like whether to keep change history, whether to save changes automatically, how to deal with conflicting changes…

How to Co-edit an Excel Workbooks with Multiple People

4. Click OK to confirm all the settings and hit OK again in the popping out window to save the workbook.

How to Co-edit an Excel Workbooks with Multiple People

5. Then you can see the document name is followed by a mark of [Shared]. It means this workbook can be edited by multiple users at the same time now.

How to Co-edit an Excel Workbooks with Multiple People

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

One response to “How to Co-edit an Excel Workbooks with Multiple People”

  1. vurtilopmer says:

    he blog was how do i say it… relevant, finally something that helped me. Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *