Question: how to open excel file by multiple users?
Answer: Click the Review tab.
Click Share Workbook in the Changes group.
On the Editing tab, click to select the Allow changes by more than one user at the same time. ... 
In the Save As dialog box, save the shared workbook on a network location where other users can gain access to it.