Excel - Locked for editing not applying

[petben]

Hello, some departments have these big spreadsheets (behaviour logs etc) that many people work on over the course of the day. Understandably staff try and access the spreadsheet when it is open by someone else. If the first person has only had it open for a short time the second person gets the message:

 

'this is lacked for editing...open read only?'

 

which is what we want, but we are finding this lock seems to timeout and 2 people can open the file without any warning, work and then lose saved changes.

 

Have tried enabling the key below on both file server and workstation to increase the share timeout to 6 hours, but this has not fixed it.

 

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters

 

any ideas?

Thanks

[3s-gtech]

You're not hosting it on a DFS-R share are you?

[petben]

it is DFS but not replicated anywhere..

[ricki]

Is the file saved on sharepoint there is a lock with SharePoint and one drive which is on SharePoint of 10 mins Richard