Sharing Workbooks

When you're working with others in a networked environment, you may want to share workbooks you created. You may also want to share the responsibilities of entering and maintaining data. Sharing means users can add columns and rows, enter data, and change formatting, while allowing you to review their changes. This type of work arrangement is particularly effective in team situations in which multiple users have joint responsibility for data within a single workbook. In cases in which multiple users modify the same cells , Excel can keep track of changes, and you can accept or reject them at a later date.

Enable Workbook Sharing

Open the workbook you want to share.

Click the Tools menu, and then click Share Workbook.

Click the Editing tab.

Select the Allow Changes By More Than One User At The Same Time check box.

Click OK, and then click OK again to save your workbook.

Change Sharing Options

Open the workbook you want to share.

Click the Tools menu, and then click Share Workbook.

Did You Know?

Excel alerts you if you are working in a shared file . When sharing is enabled, "[Shared]" appears in the title bar of the shared workbook.

Click the Advanced tab.

To indicate how long to keep changes, select one of the Track Changes options, and then if necessary, set the number of days.

To indicate when changes should be saved, select one of the Update Changes options, and then if necessary, set a time internal.

To resolve conflicting changes, select one of the Conflicting Changes Between Users options.

Select one or both of the Include In Personal View check boxes.

Click OK.