Collaborate Using Excel 2007 Part II

More than one person can edit a shared workbook at the same time. This makes collaborating on Excel spreadsheets much easier.

In Part I of Collaborate using Excel 2007, you learned how to create a shared workbook. Now you’ll learn how to edit a shared workbook.

To edit a shared workbook, you first need to locate and open it from its network location. Once you’ve opened the shared workbook, complete the steps outlined below.

  1. Click the Microsoft Office Button and click Excel Options.
  2. In the Popular category, under Personalize your copy of Office, in the User Name box, enter your user name to identify your work within the workbook.
  3. Click OK.
  4. Enter your data into the workbook.
  5. Once you are complete, click the Save button.

Your changes will be saved to the workbook and other users will be able to view them.

[awsbullet:Microsoft Office Home and Student 2007]