No 'locked for editing' message for an Excel file on a network share

Question

I get no 'locked for editing' message when accessing an Excel spreadsheet file on a network share (Windows SBS 2011 Standard) even though the file is open by a different user on a different workstation (Office 2013, Windows 8.1).

Is there any way of getting this fixed or should I just accept the fact that it won't work as intended?

We use Sophos, I've already tried excluding .xls files from real time scanning but the problem still persists.

Have you actually tried to edit and save the file while it's reportedly open by someone else? — joeqwerty, Nov 11 '15 at 14:47
Yes. This results in someone's else's work being overwritten. — Dam, Nov 11 '15 at 15:05

score 1 · Answer 1 · answered Feb 16 '17 at 11:19

There's a possible answer at: https://helpdesk.yourofficeanywhere.co.uk/kb/a183/excel-loses-file-locked-for-editing-when-accessing-data-on-network-drive-mapped-via-group-policy.aspx

In summary: If the file is on a drive mapped by group policy, the periodic policy refresh can disconnect and reconnect the drive, causing the lock to vanish. You can change the action setting on the group policy from Replace to Update which should ensure that the connection doesn't get dropped.

score 0 · Answer 2 · answered Nov 23 '21 at 19:32

0

DFS will cause this, the users may be on different DistributedFileServer servers.

answered Nov 23 '21 at 19:32

FooBar

76
1

is this a comment, or how does this answer the question? – djdomi Nov 30 '21 at 18:29

No 'locked for editing' message for an Excel file on a network share

2 Answers2