Normally, Excel updates an open, shared workbook with other users’ changes only when
you save the workbook. Likewise, other users see your changes only when they save the file
after you save your work. In a fast-paced environment in which several users are editing a
workbook simultaneously, you might want to see and save changes more often. Follow these
steps to adjust automatic update options:
1.Open or switch to the shared workbook and select Tools, Share Workbook.
2.Click the Advanced tab to display the dialog box shown in Figure 29.10.
29
Figure 29.10
Use this dialog box to
update changes to a
shared workbook ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.