Question

What are options in the Advanced tab in the Share Workbook dialog box? Check all that apply.

Answer 1

All options in the Advanced tab in the Share Workbook dialog box.

• Don’t keep change history
• Show comments made by all users
• Update changes when file is saved
• Track changes for certain amount of days
• Allow changes by more than one user at a time
• Automatically update changes in certain time periods

Explanation:

In shared workbook in advanced tab it has following options. Based on end user selection changes are applied on shares workbook.

1. Either keep the history for certain period or don’t keep the history on shared workbook.

2. On share work Save changes on period schedule (automatically update) or just see other user changes.

3. Before changes are made for share workbook either prompt for save option or last modified saved.

4.  Printer review and filter setting for personal view.

Answer 2

My life is a lie.

Allow changes by more than one user at a time

Automatically update changes in certain time periods