.
Excel is generally not designed to allow more than one user to access the file at one time.

This resource explains about SHARING so more than one user can : https://support.office.com/en-us/art...2-c1c59a628534

Another idea others have used is to have a MASTER file that periodically checks each individual users file for changes. The MASTER file is not accessed by the users, it simply updates itself with any
changes made to each individual user's file.

Lastly, Microsoft has a CLOUD version of EXCEL that can be used for more than one person to access at the same time.