Best way to share excel data

[gheyman]

I have a very simple basic excel sheet where we store data. I have about six people that enter data and about 30 people that open the sheet just to get data. The problem is, the sheet is always open by someone and the 6 people can never enter data because it opens as read only.

What's my best or any option. I tried creating a linked table in a separate spreadsheet for the read only people, but there seems to a mapping issue. some people cannot open it. I know they all have permissions to where I am putting the new sheet that contains the table, but it seems that IT is mapping peoples drives differently. So that option is causing me heartburn.

Any suggestions?

Thanks

 

[LouisT]

Save the file so that only the 6 people who enter data have Read/Write access and everyone else will have to open as Read Only.

 

[gheyman]

That may help some. But my other six will still be battling to open it in write mode.

 

[LouisT]

No, you can make it so it can be "shared" so that multiple people can edit it but they just need to make sure 2 of them aren't saving at the same time. Additionally if you're on Office 365, you can have the document online that allows many users at once to edit the same document and it will prompt you when someone makes and saves changes.