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

✦ UpdateChanges:Enablesyoutoselectwhenchangesmadebydifferent users are saved. By default, Excel saves changes when the file is saved. To have the program save changes every so many minutes, click the Automatically Every option button and then enter the number of minutes for the save interval in the Minutes text box or select this interval value with its spinner buttons. When automatically saving changes every so many minutes, by default Excel saves only your changes while showing you changes made to the workbook by others. To have the program just display the changes made to the file by others when the save interval
is reached without saving your changes, click the Just See Other Users’ Changes option button.
✦ Conflicting Changes Between Users: Enables you to select how changes made to the same cells of a shared workbook by different users are treated. By default, Excel is set to ask you which user’s changes to accept and which to deny. If you want Excel to accept the changes made by any user at the time she saves the workbook, click the Changes Being Saved Win option button.
✦ IncludeinPersonalView:Enablesyoutodeterminewhichofyourper- sonal settings are saved when you save the workbook. By default, Excel saves both your personal print settings (including such things as page breaks, changes to the print area, and changes to the printing settings — see Book II, Chapter 5 for details) and the filtering settings you select with the AutoFilter buttons. (See Book VI, Chapter 2 for details.) Deselect the Print Settings and/or Filter Settings check boxes at the bottom of the Advanced tab if you decide that you don’t need these settings saved as part of the shared workbook.
Turning on change tracking
The second way to share a workbook is by turning on change tracking. When you do this, Excel tracks all changes you make to the contents of the cells in the shared workbook by highlighting their cells and adding comments that summarize the type of change you make. When you turn on change tracking, Excel automatically turns on file sharing along with the workbook’s Change History log.
To turn on change tracking in a workbook, you take these steps:
1. Open the workbook for which you want to track changes and that you wish to share and then make any last-minute edits to the file, especially those that are not supported in a shared workbook.
When making these last-minute changes, keep in mind that, when you share a workbook, some of Excel’s editing features become unavailable to you and any others working in the file. (Refer to the “Workbook Sharing 101” section, earlier in this chapter, for a list of exactly which features are unavailable.)
Workbook Sharing 101 475
Book IV Chapter 3
Sending Workbooks Out for Review