Excel Mutiple User Problem

[gheyman]

I have (inherited) a spreadsheet where about 5 people enter data and about 20 other people view the data. My problem is the 5 people can never enter data because someone else always has it open. Any suggestions as to a what would work in this situation? How can I have a spreadsheet where if someone needs to enter data they can and not have to worry about other people being in it?

Its a very basic spreadsheet with about 20 columns and its a dumb sheet. Basically a table (FYI This company doesn't like Microsoft Access)

 

[Logit]

Excel does not play well with more than one person accessing a workbook at the same time.

I've never used OneDrive but from Microsoft's description this may be a solution (see attached).

A workaround would be to have a separate file on the server .. one for each employee. This would require each employee
does not need to know the entries of the other employees ... or their entry is not dependent on something the others entered.

Then you could have a master file that loops thru their individual workbooks on the server, copies their entries, then pastes everything
in the Master File for you to review.

???

Download document : https://www.amazon.com/clouddrive/share/1BC100PAdbiqTjhTAYiWsmAz8dvR9TAg6ExP32D3liy