Sharing a Workbook

To share a workbook, use the following procedure.

1. Select the Review tab from the Ribbon.
2. Select Share Workbook.

3. In the Share Workbook dialog box, check the Allow changes by more than one user at the same time box.
4. Select OK.
5. In the Save As dialog box, enter a new File Name, if desired. Navigate to the location where you want to save the workbook and select Save.

Note that if there are links in the workbook, you may need to verify them. Now you can email the people who will share the workbook a link to the file or indicate the location of the file.

For Microsoft Excel training classes in Los Angeles call us on 888.815.0604.

Editing a Shared Workbook

To edit a shared workbook, use the following procedure.

1. Open the shared workbook.
2. Make any necessary changes.
3. Save the workbook.

You can see who else has the workbook open on the Editing tab of the Share Workbook dialog box.

1. Select the Review tab from the Ribbon.
2. Select Share Workbook.

Select the Advanced tab of the Share Workbook dialog box to choose to get automatic updates of the other users' changes periodically, with or without saving.

Tracking Changes

To turn on change tracking for a workbook, use the following procedure.

1. Select the Review tab from the Ribbon.
2. Select Share Workbook.
3. Select the Advanced tab of the Share Workbook dialog box.

4. Excel keeps the change history for a default of 30 days. You can change the number of days.
5. Select OK.

To review the Highlight Changes dialog box, use the following procedure.

1. Select the Review tab from the Ribbon.
2. Select Track Changes. Select Highlight Changes.

3. In the Highlight Changes dialog box, you can select when to highlight changes, whose changes to highlight and where to highlight the changes. Select OK when you have finished making your selections.

Merging Copies of a Shared Workbook

To add the Compare and Merge Workbooks command to the Quick Access toolbar, use the following procedure.

1. Select the arrow next to the Quick Access Toolbar.
2. Select More Commands from the menu.

3. In the Excel Options dialog box, select All Commands from the Choose Commands From drop down list.
4. Highlight Compare and Merge Workbooks in the left list.
5. Select Add.

6. Select OK.

To compare and merge workbooks, use the following procedure.

1. Open the copy of the shared workbook where you want to merge the changes.
2. On the Quick Access Toolbar, click Compare and Merge Workbooks.

3. Save the workbook if prompted.
4. In the Select Files to Merge into Current Workbook dialog box, select a copy of the workbook that contains the changes that you want to merge. Hold down CTRL or SHIFT to select multiple copies. Select OK.