Chapter 30: Using Excel in a Workgroup
631
Caution
If you save an Excel 2010 shared workbook to an earlier version file format (such as *.xls), sharing is turned off,
and the revision history (if any) is lost. n
Designating a workbook as a shared workbook
To designate a workbook as a shared workbook, choose Review ➪ Changes ➪ Share Workbook.
Excel displays the Share Workbook dialog box, shown in Figure 30.3. This dialog box has two
tabs: Editing and Advanced. On the Editing tab, select the Allow Changes check box to allow
changes by multiple users and then click OK. Excel then prompts you to save the workbook.When you open a shared workbook, the workbook window’s title bar displays [Shared]. If you
no longer want other users to be able to use the workbook, remove the check mark from the
Editing tab of the Share Workbook dialog box and save the workbook.Tip
Whenever you’re working with a shared workbook, you can find out whether any other users are working on
the workbook. Choose Review ➪ Changes ➪ Share Workbook, and the Editing tab of the Share Workbook dia-
log box lists the names of the other users who have the file open, as well as the time that each user opened the
workbook. n
FIGURE 30.3Use the Share Workbook dialog box to control the sharing of your workbooks.