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

474 Workbook Sharing 101
Modifying the Share Workbook options
As soon as you turn on file sharing for a workbook, Excel also turns on a Change History log that records all the changes made by different individu- als to the same workbook file. You can use the Change History log to view information about the various changes made to a shared workbook and to determine which of the changes to retain if conflicting changes are made
by different people to the same cells of a workbook. You can also use the Change History log when merging changes from different copies of the same workbook into a single file.
By default, Excel maintains the Change History log for a period of 30 days from the date that you first share the workbook. If you wish, you can change the length of time that Excel maintains the Change History log or even, in rare circumstances, elect to not keep the log.
To make changes to the length of time that Excel maintains the Change History log, you click the Advanced tab in the Share Workbook dialog box (Alt+RW), as shown in Figure 3-6. This tab contains the following sections with options for not only changing how long the Change History log is main- tained, but also controlling when and how updates are handled:
✦ Track Changes: Enables you to modify how long Excel keeps the Change History log by entering a new value in the Keep Change History For text box or selecting a new value with the spinner buttons. Click the Don’t Keep Change History option button should you ever decide that you don’t need the Change History log.
Figure 3-6:
Modifying the sharing options
on the Advanced tab of the Share Workbook dialog box.