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
<u>Explanation:</u>
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:
I had a similar problem. I would suggest consulting someone professionally because thats what I had to do. I really dont know why it does that
