update links
 

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

update links
 

Hi Spike

Look on the Edit tab in ToolsOptions

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



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


"Spike" wrote in message ...
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

update links
 

Yes

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


"Spike" wrote in message ...
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


"Ron de Bruin" wrote:

Hi Spike

Look on the Edit tab in ToolsOptions

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



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


"Spike" wrote in message ...
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

update links
 

Many thanks.
--
with kind regards

Spike


"Ron de Bruin" wrote:

Yes

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


"Spike" wrote in message ...
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


"Ron de Bruin" wrote:

Hi Spike

Look on the Edit tab in ToolsOptions

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



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


"Spike" wrote in message ...
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