Cloud Drive File issues

[JackDoyne]

Basically we have a small network drive in the office with loads of files on it 

 

there is a certain spreadsheet that several members of staff use, however there doesn't seem to be any notification to if someone else has that spreadsheet open, therefore we are constantly losing data on this spreadsheet as more than one person has it open at certain times, although the easy solution would be to ask around the office and tell them close it, however these are people outside of the office and they aren't easily contactable 

 

any ideas?

[Technomancer__]

next to the file make a .txt file with the same name

write all the names of the people that are using it

when someones opens the file he opens the file and adds - in front of there name or another symbol

when the close the file the remove it