Advanced Sharing  Options

In addition to the Editing options, there are Advanced options when you Share a Workbook. Let's review them now.

 

4. Try it: Review the Advanced Options

The Advanced Sharing options include:

 

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

 

Update Changes: By default, the changes are updated each time a file is saved. They can also be set to update automatically.

 

Conflicting changes between users: You can choose to be asked ore let the last saved change "win."

 

Include in personal view: The Print and Filter settings are both included by default.

 

Click CANCEL and keep going...

Exam 77-888: Microsoft Excel Expert 2010

1. Sharing and Maintaining Workbooks

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

Review ->Changes-> Share Workbook