One way:

With ThisWorkbook
.UpdateLink Name:=.LinkSources
End With

In article ,
"Danny" wrote:

I have a spreadsheet which retrieves data from several
other spreadsheets. When i open this spreadsheet it asks
me would i like to update the links and i click Yes and my
data is now current.

Does anyone know the code for this update. I want a button
which will run the same script as when i click Yes on
entry to the spreadsheet to update the links.