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

482 Workbook Sharing 101
Figure 3-9:
Deciding whether or not to accept a change in the Accept or Reject Changes dialog box.
If you know ahead of time that you want to accept or reject all the changes that have been made since you last reviewed the workbook or the date you specified, click the Accept All button or the Reject All button, respectively. When you accept or reject the last change identified in the workbook, the Accept or Reject Changes dialog box automatically closes, and you can then save the workbook (Ctrl+S) with the editing changes made as a result of this review.
How to stop sharing a workbook
If you decide that you no longer want to share a particular workbook, you can turn off file sharing. To do this, open the Share Workbook dialog box (Alt+RW) and remove the check mark from the Allow Changes by More Than One User at the Same Time check box on the Editing tab before you click OK.
As soon as you click OK, Excel displays an Information alert dialog box indi- cating that your action is about to remove the workbook from shared use and, at the same time, erase the Change History log. It also informs you that users who are currently editing this workbook will be unable to save their changes even if you should later change your mind and turn the file sharing back on again.
Because users are prevented from saving their changes and the Change History log is erased as soon as you turn off file sharing and make the work- book once again exclusive, you don’t ever want to turn off file sharing until after you’re sure that you have everybody’s comments and changes saved to the workbook and have reviewed and merged the changes you want to keep.
If you’re sure that you’ve met these two conditions, you can click the Yes button in the Information alert dialog box to turn off file sharing and once again make the workbook your exclusive property. Click the No button, how- ever, to abort this procedure if you have any doubt about having all your users’ changes erased.