Share Workbooks

 

Highlight Changes | Accept/Reject Changes

If you share a workbook in Excel 2016 or older versions, you can work with other people on the same workbook at the same time. The workbook should be saved to a network location where other people can open it. You can keep track of the changes other people make and accept or reject those changes.

To share a workbook, execute the following steps.

1. Open a workbook.

Workbook in Excel

2. On the Review tab, in the Changes group, click Share Workbook.

Click Share Workbook

The Share Workbook dialog box appears.

3. On the Editing tab, click the check box and click OK.

Who has this Workbook Open Now

Excel saves the workbook. You can now work with other people on the same workbook at the same time. The screen above shows you who has the workbook open.

Highlight Changes

You can highlight the changes on screen other users has made.

1. On the Review tab, in the Changes group, click Track Changes.

Track Changes

2. Click Highlight Changes.

Click Highlight Changes

The Highlight Changes dialog box appears.

3. Click OK.

Highlight Which Changes

Excel highlights the changes on screen.

Change Highlighted

Apparently, Aiden has changed the Sales of Smith from $16,753.00 to $26,753.00.

Accept/Reject Changes

You can now accept or reject this change.

1. On the Review tab, in the Changes group, click Track Changes.

Track Changes

2. Click Accept/Reject Changes.

Click Accept/Reject Changes

3. Click OK.

Select Changes to Accept or Reject

4. Click Accept to accept the change or Reject to reject the change.

Reject Change

Note: not all features are available in a shared workbook.