DataConnection opens source Excel file during .RefreshALL [VBA]

[Caleeco]

Hello,

Got an issue which I can't seem to resolve. I have a Workbook Connection from Workbook A (.xlsb) to another Excel Workbook B (.xlsm) on the network. The data is updated with the following code:

Private Sub Workbook_Open()

    Call HideAllSheets
    ActiveWorkbook.RefreshAll
    DoEvents

End Sub

However, on (random) occasions the SOURCE workbook (Workbook B) opens in read-only. I can only assume, this is when another user has the file open?
How do I stop this from happening?

Your help would be much appreciated.
Cheers

Caleeco

 

[Caleeco]

Any ideas?

Thanks
Caleeco

 

[Caleeco]

Bump!

Any help is appreciated

Cheers
Caleeco