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

476 Workbook Sharing 101
Before turning on file sharing, you may want to save the workbook in a special folder on a network drive to which everyone who is to edit the file has access.
2. Choose File➪Save As or press Alt+FA and then select your SkyDrive or the network drive on the Save As screen; then, in the Save As dialog box, select the folder in which you want to the make the change track- ing version of this file available before you click the Save button.
3. Choose the Highlight Changes option from the Track Changes com- mand button’s drop-down menu on the Review tab or press Alt+RGH.
Doing this opens the Highlight Changes dialog box, shown in Figure 3-7, where you turn on change tracking and indicate which changes to high- light.
Figure 3-7:
Turning
on change tracking in the Highlight Changes dialog box.
4. Select the Track Changes While Editing check box.
Doing this turns on change tracking and automatically turns on file shar-
ing for the workbook.
By default, Excel selects the When combo box and chooses the All option from its drop-down menu to have all changes made to the work- book tracked. To track the changes only from the time you last saved the workbook, choose the Since I Last Saved item from the When drop- down menu. To track all changes that you’ve not yet reviewed (and decided whether to accept), you choose the Not Yet Reviewed item from the When drop-down menu. (Most often, you want this option so that you can use the Accept/Reject Changes option on the Track Changes command button’s drop-down menu to review each person’s changes and decide whether to keep them.) To track changes from a particular date, choose Since Date from the When drop-down menu: Excel then inserts the current date into the When combo box, which you can then edit, if necessary.