O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required