Take a look at UpdateLink in VBA's help for a nice example:

ahhh. From xl2002's help:

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources

Joe User wrote:

I have a macro in an excel workbook. After the macro is
done I would like to update all links that are in each
sheet. What is the propper syntax for that?

--

Dave Peterson