Page 497 - Excel 2013 All-in-One For Dummies

Workbook Sharing 101 479
Figure 3-8:
Displaying the comment added
to a cell highlighted by change tracking.
Merging changes from different users
At some point after sharing a workbook, you’ll want to update the work- book to incorporate the changes made by different users. When merging changes, you may also have to deal with conflicting changes made to the same cells and decide which changes to accept and which to reject. After you’ve merged all the input and decided how to deal with all the conflicting changes, you may even want to turn off file sharing to prevent users from doing any further editing.
To be able to compare versions of a shared workbook and incorporate changes from your co-workers, you need to add the Compare and Merge Workbooks command button to the Quick Access toolbar:
1. Click the Customize Quick Access Toolbar button at the end of the Quick Access toolbar and then choose the More Commands option.
Excel opens the Excel Options dialog box with the Quick Access Toolbar tab selected.
2. Choose the Commands Not in the Ribbon option from the Choose Commands From drop-down menu.
Excel displays a list of all the commands not currently on the Ribbon in the list box beneath the Choose Commands From drop-down box.
Book IV Chapter 3
Sending Workbooks Out for Review