Is it possible to—on open—update links without prompt in Excel VBA?
Yes the links will be updated.
From the offline help:
This code will suppress all the dialogs whilst forcing the links to update:
Private Sub Workbook_Open()
With Application
.DisplayAlerts = False
.AskToUpdateLinks = False
.DisplayAlerts = True
End With
End Sub