Open Excel Workbooks by Multiple People

First of all, you need to save the Excel file to a place on the RRU network where everyone has appropriate permissions.

Open the Excel File
Go to the Review tab and click on Share Workbook
Warning: If the Excel file has any tables, then it can not be shared in this way
You will then see the following window, just make sure that the box is checked beside Allow changes by more than one user at the same time. This also allows workbook merging. You can also remove a user here...
You can just leave the default settings as they are or change them to suit your needs:
Click OK to save the changes then save the Workbook to finalize them.

IT-Services Knowledge Base