Sharing Data Lists
To enable several users to edit a workbook
To turn on workbook sharing, on the Review tab, in the Changes
You can't share a workbook that contains a data table. To share the workbook, convert the table to a regular
On the Advanced tab of the Share Workbook dialog box, two settings are of particular interest. The first determines whether Microsoft Office Excel 2007 should maintain a history of changes made to the workbook and, if so, for how many days it should keep the changes. The default setting is to retain a record of all changes made in the past 30 days, but you can enter any number of days you like. Unless it's critical that you keep all changes made to a workbook, you should probably stay with the default setting of 30 days so the list doesn't become too large and unwieldy.
The other important setting on this tab deals with how Office Excel 2007 decides which of two conflicting changes in a cell should be applied. For example, a service level's price might change, and two of your colleagues might type in what they think the new price should be. Selecting the Ask Me Which Changes Win option button enables you to decide which price to keep.
Another way to share a workbook is to send a copy of it to your colleagues via e-mail. Although the specific command to attach a file to an e-mail message is different in every program, the most common method of attaching a file is to create a new e-mail message and then click the Attach button, as in Microsoft Office Outlook 2007.
In this exercise, you turn on workbook sharing and then attach the file to an Office Outlook 2007 e-mail message.
You must have Outlook 2007 installed on your computer to follow this procedure exactly.
USE the Cost Projections workbook in the practice file folder for this topic. This practice file is located in the My Documents\Microsoft Press\Excel SBS\Sharing folder.
BE SURE TO start Excel 2007 before beginning this exercise.
BE SURE TO start Outlook 2007 before beginning this exercise.
CLOSE the Cost Projections workbook.
Microsoftu00ae Office Outlooku00ae 2007 Step by Step (Step by Step (Microsoft))
Microsoftu00ae Office PowerPointu00ae 2007 Step by Step (Step By Step (Microsoft))
Microsoftu00ae Office Word 2007 Step by Step (Step By Step (Microsoft))
Microsoftu00ae Office Access(TM) 2007 Step by Step (Step By Step (Microsoft))