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

Figure 3-5:
Turning on file sharing on the Editing tab of the Share Workbook dialog box.
Workbook Sharing 101 473
4. Select the Allow Changes by More Than One User at the Same Time check box on the Editing tab.
By default, Excel maintains a Change History log for 30 days. If you wish, you can use the Advanced tab settings to modify whether Excel main- tains this Change History log (necessary if you want to reconcile and merge changes) or to change how long the program saves this log. You can also change when changes are updated, how conflicts are handled, and whether your print settings and data filtering settings are shared.
5. (Optional) Click the Advanced tab and then change the options on this tab that affect how long a change log is maintained and how editing conflicts are handled.
See the following section, “Modifying the Workbook Share options,” for details on changing these settings.
6. Click the OK button to close the Share Workbook dialog box.
As soon as Excel closes the Share Workbook dialog box, an alert dialog box appears, telling you that Excel will now save the workbook and asking you if you want to continue.
7. Click the OK button in the Microsoft Excel alert dialog box to save the workbook with the file sharing settings.
Immediately after you click OK and close the alert dialog box, Excel saves the workbook, and the [Shared] indicator appears at the end of the filename on the Excel program window’s title bar.
Book IV Chapter 3
Sending Workbooks Out for Review