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

480 Workbook Sharing 101
3. Click the Compare and Merge Workbooks item in the list box below
and then click the Add button.
The Compare and Merge Workbooks item appears below the last item in the Quick Access Toolbar list box on the right side of the Excel options dialog box.
4. Click the OK button to close the Excel Options dialog box.
The Compare and Merge Workbooks button appears at the end of the
Quick Access toolbar. (Its icon is an outlined circle.)
When you click the Compare and Merge Workbooks button that you added to the Quick Access toolbar with the original workbook file open in Excel, the program opens the Select Files to Merge Into Current Workbook dialog box. Here, you select the drive and folder that contain the copies of the shared workbook file edited by your co-workers.
Resolving conflicts
Should Excel identify cells in the workbook that contain conflicting changes (that is, different values placed in the same cell by different users) after you select their files in the Select Files to Merge Into Current Workbook dialog box, it flags the cells in the original workbook open in Excel and then dis- plays the conflict in the Resolve Conflicts dialog box. To accept your change to the cell in question, you click the Accept Mine button. To accept the change made by another user, you click the Accept Other button instead.
After you accept your change or the other user’s change in the case of the first conflict, Excel flags the next case and displays a description of the con- flicting values in the Resolve Conflicts dialog box. When you finish accepting or rejecting your change or the one made by another user for the last con- flicting value, Excel automatically closes the Resolve Conflicts dialog box, and you can save your changes to the workbook by choosing File➪Save or by pressing Ctrl+S.
If you want Excel to accept only your changes in all cases of conflicting values, click the Accept All Mine button. To have Excel reject all your changes and accept all those made by others, click the Accept All Others button instead.
If you know that you always want all your changes to be accepted in the case of conflicting values, open the Share Workbook dialog box (Alt+RW) and then click the Changes Being Saved Win option button on the Advanced tab before you click OK. If you prefer to have your changes (including conflict- ing ones) automatically saved at set intervals, click the Automatically option button and set the number of minutes between saves in the Minutes text box before you click OK.