Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours

Setting Up a Shared Workbook

The Tools, Shared Workbook selection lets you set up options for sharing workbooks on a network. The shared workbook options include the following:

• Allow Simultaneous Access to a Workbook

• Control How to Track Changes

• Control How Changes Get Updated

• Control How Conflicting Changes Are Resolved

The first option in the preceding list is found on the Editing tab in the Share Workbook dialog box.

The other options in the list are on the Advanced tab in the Share Workbook dialog box.

The steps in the following To Do exercise show you how to set up shared workbooks. If you're not working on a network, you should be able to set up most of the options successfully and still be able to share workbooks and track changes. You use ...