Excel file edit multiple user issue

[nparsons75]

Hi, I have a file which is located on an internal network. The file needs to be editable at one person at a time. Whoever opens the file first, will be able to edit. Anyone opening after this should be notified that the file is locked due to another user having it open. They will then be notified once the other user closes it. This is how its supposed to work. However, currently I am being told that two users have managed to open the file simultaneously and make changes. One of whom was warned that changes have been made by another user....

The file is NOT shared, I do not have sharing on.

Does anyone know how this can possibly be happening?

Thanks in advance...

 

[ranman256]

so the 2nd person did not get the warning that it was open?

 

[nparsons75]

Hi, no they didn't. In some cases the file will open (with read only) attached to the file name at the top. The second person has managed to open the file and make changes. When the first person comes to close the file the message appears saying other changes have been made. This is a big problem as one of them is going to lose their work.

 

[ranman256]

open the workbook, enter VBE (alt-F11)
in the left pane , Projects, dbl-click the ThisWorkbook object
in the right pane, the code area, paste the following:

Private Sub Workbook_Open()
CheckIsOpen
end sub


Public Sub CheckIsOpen()
If ActiveWorkbook.ReadOnly Then
    MsgBox "The file is in use by another"
    ActiveWorkbook.Close False
End If
End Sub

 

[nparsons75]

Hi, thanks, I will give that a go. How come I need to add this, should excel not do this naturally? Or is it that its common to fail on this. Just to help me understand why it's happening. Thank you. I will also feedback once tested.

 

[nparsons75]

Hi, this did bring up a message, however, for users that have macros requiring manual enabling, the message will not show until the macro's have been enabled?

Thanks,