Share a Workbook

This discussion began by reviewing the steps to Protect a sheet or workbook. The next pages will look at how to Share.

 

3. Try it: Share a Workbook

Go to Review ->Changes.

Click on Share Workbook.

 

What Do You See? By default, there is a check mark to allow changes by more than one user at the same time. The Editing tab also displays who currently has the  workbook open.

 

What Else Do You See? Before you Share a Workbook, it will be marked as Exclusive: only one person can edit it at a time. After you Share a Workbook, it will no longer be listed as Exclusive.

 

Keep going..

Review ->Changes-> Share Workbook

Exam 77-888: Microsoft Excel Expert 2010

1. Sharing and Maintaining Workbooks

1.2. Apply protection and sharing properties to workbooks and worksheets.