The “Allow changes by more than
one user at the same time” option.
In a
group of users, it is very important to create a shared workbook so that
several people are able to update information and track changes in the workbook
at the same time. To do so, one should click on the review tab of the excel sheet and select
share workbook. On the editing tab of the share workbook dialog box, select the
Allow changes by more than one user at the same time check box. Go ahead and
click the advanced tab and select option you would want to use and then click
OK
