How to make Excel shared workbook 2010

Share workbook allow multiple people to work in a workbook at the same time. Note you can allow changes by more than one user at the same time. This also allows workbook merging. The workbook should be saved to a network location where multiple people can open it. You can also watch who has the current workbook opened. Click the Insert tab then click Share Workbook. Check Allow changes then click OK. Click Save. The result: your workbook mark as Shared.

Step 1: Click Review tab then click Share Workbook button.

Step 2: Check Allow changes then click OK.

Step 3: Name the file then click Save.

Result: Your workbook mark as shared.



share-workbook-excel-2010 shared-workbook excel-2010-basics