Automatically update links to avoid popup

[S Oberlander]

My code opens a workbook with external links, and gives the below popup. How can I have this happen automatically so the users do not get bothered by this?
I'm posting my code too in case it matters.

Dim el As Workbook  
Set el = Workbooks.Open(Filename:="file:///\\SERVER\Pricing\Last Twelve Details.xlsb")
'pops up here, I do not want to see the popup
'some stuff is copied over to a different workbook
el.Close savechanges:=False

 

[gordsky]

In 365 try the following

1. Go to Data > Queries & Connections > Edit Links.
2. Click Startup Prompt.
3. Click Dont display alerts and update links.

 

[Micron]

Isn't that a machine specific setting that you'd have to perform on every user's pc? I was thinking of this in the workbook module:

Private Sub Workbook_Open()
Application.ThisWorkbook.UpdateLinks = xlUpdateLinksAlways
End Sub

 

[S Oberlander]

Isn't that a machine specific setting that you'd have to perform on every user's pc? I was thinking of this in the workbook module:

Private Sub Workbook_Open()
Application.ThisWorkbook.UpdateLinks = xlUpdateLinksAlways
End Sub

It's still giving me the popup

 

[Micron]

Sorry then, I don't know what else to suggest. Are you sure that runs? You could put Stop as the first line to find out.

 

[S Oberlander]

I ended up removing links to external workbooks

 

[S Oberlander]

In 365 try the following

1. Go to Data > Queries & Connections > Edit Links.
2. Click Startup Prompt.
3. Click Dont display alerts and update links.

can't believe I missed this
I just googled this issue again and bumped into it...