Locked for Editing, Read Only / Notify

[Dazzybeeguy]

We have a spreadsheet at work that a lot of us end up trying to access and input into the spreadsheet at the same time. When someone else is in you get the pop up box telling you it is locked for editing and to select read only or notify.

Is there a solution to this in Office 365 so several people can add to it at the same time, or as they would be trying to type in the same cells is that a no no ?

Thanks