Sharing a Workbook in Excel for Simultaneous Edit or Modification:

Multiple users can share and modify excel  workbook.  Updated data will be available all the time. You can track changes across network using user’s login name and the date they made update. Workbook however needs to be kept in a shared network. 

           Open your workbook.

               Navigate to Review on the toolbar

               Click on the Share Workbook icon

               Place a check on the check box that says Allow more than one user at the same time.

               Click on OK

               Now, save your workbook on a network share