I have searched the forum and have obviously missed the answer to this.

I will be very grateful for the code for when you open a workbook that is
linked to another with just 6 links it automatically updates all the links.
At the moment when it opens it asks to update links and if i select yes then
a further msgbox appears and i have to select each link in turn.

If i run the code as below i still have to select each link in the msgbox
how do i avoid this as i suppose it is just providing the link to the source.

Tools/Options/Calculation/Update Remote References is checked.

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources
--
with kind regards

SPike