Part IV: Using Advanced Excel Features
632
Controlling the advanced sharing settings
Excel enables you to set options for shared workbooks. Choose Review ➪ Changes ➪ Share
Workbook and click the Advanced tab of the Share Workbook dialog box to access these options
(see Figure 30.4).FIGURE 30.4Use the Advanced tab of the Share Workbook dialog box to set the advanced sharing options for your
workbook.
Tracking changes
Excel can keep track of the workbook’s changes: its change history. When you designate a work-
book as a shared workbook, Excel automatically turns on the Change History option, enabling you
to view information about previous (and perhaps conflicting) changes to the workbook. You can
turn off change history by selecting the Don’t Keep Change History button. You can also specify
the number of days for which Excel tracks change history.If you plan to use shared workbooks, spend time experimenting with the various settings to ensure that
you understand how sharing works. You don’t need to enlist a colleague to help you — you can share
a workbook with yourself. Just launch a second instance of Excel and then open a shared workbook in
both instances. Make changes, save the file, adjust the settings, and so on. Before long, you’ll have a
good understanding of Excel’s shared workbooks.Sharing a Workbook with Yourself