How do I stop data being lost between multiple data entry users on sheets?

Options

We are using a sheet format for our delivery manifests and between admin entering the data and the dispatch office changing data, adding and moving lines around, some of the data and changes are being lost in this movement.

I have encouraged the users to use the refresh function before using the sheet and use the save function regularly. Is this the actual solution or is there another way I can stop the data being lost?

Answers