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