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.
- Click the Microsoft Office Button and click Excel Options.
- 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.
- Click OK.
- Enter your data into the workbook.
- 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]