Excel: What Happened? (Page 1) 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44

Review ->Changes ->Protect and Share

Protect and Share

If you are editing this workbook in a group or department, you can Protect and Share your file.

 

Try it: Protect and Share
Go to Review->Changes.
Select Protect and Share.



Editing: The first tab displays who is currently working on the workbook.

 

Advanced: When you Share a Workbook, you can Track Changes. You can keep a history of all the changes and specify how many days you need to keep in the log.

 

If there is a conflict when two or more users are editing the same file, you can ask which changes win.

 

 

  Microsoft Excel 2007 Exam 77-602 Topic: 5.  Collaborating and Securing Data

  5.2.1. Protect workbooks and worksheets: Enable workbooks to be changed by multiple users