update links

[Spike]

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

 

[Ron de Bruin]

Hi Spike

Look on the Edit tab in Tools>Options

See "Ask to update................"

 

[Spike]

Thank you, i had looked at that and it is checked ie ask to update do you
mean it should not be checked?
--
with kind regards

Spike

Hi Spike

Look on the Edit tab in Tools>Options

See "Ask to update................"

 

[Ron de Bruin]

Yes

--
Regards Ron de Bruin
http://www.rondebruin.nl

Thank you, i had looked at that and it is checked ie ask to update do you
mean it should not be checked?

 

[Spike]

Many thanks.
--
with kind regards

Spike

Yes