I have some MainBook, which have links through LookUp
function with many other books Book1,Book2,... . Those
books have thier own links through LookUp with MainBook as
well. AnotherBook have links (through LookUp) with those
books (Book1,...) too.

I'm douing the links update from MS Access.
I'm trying to do it by using the following for all these
books:

xlapp.AskToUpdateLinks = False
Set xlbook = xlapp.Workbooks.Open(...)

With xlbook

.UpdateLink Name:=xlbook.LinkSources

End With

Please, advise whether it's enough to have those links
updated.

Thanks in advance.

There will be no ripple effect, so you would need to open the workbooks at
the lowest level of a chain of links first and work upward in a breadth
first manner.

--
Regards,
Tom Ogilvy

"Alex" wrote in message
...
I have some MainBook, which have links through LookUp
function with many other books Book1,Book2,... . Those
books have thier own links through LookUp with MainBook as
well. AnotherBook have links (through LookUp) with those
books (Book1,...) too.

I'm douing the links update from MS Access.
I'm trying to do it by using the following for all these
books:

xlapp.AskToUpdateLinks = False
Set xlbook = xlapp.Workbooks.Open(...)

With xlbook

.UpdateLink Name:=xlbook.LinkSources

End With

Please, advise whether it's enough to have those links
updated.

Thanks in advance.

Thanks a lot, Tom.
However, in this case, I need to ask you the following
questions:

1. Should all these books be opened during this time?
2. I have a situation when cells A1:A100 from the MainBook
are linked to the cell B1 in Book1,Book2, ... and cell D1
from those Book1,Book2 is linked to some specific cell
from column H of MainBook. Everything is through LookUp.
Will all these links be updated in this case?

Regards,

Alex

-----Original Message-----
There will be no ripple effect, so you would need to open
the workbooks at
the lowest level of a chain of links first and work
upward in a breadth
first manner.

--
Regards,
Tom Ogilvy

"Alex" wrote in
message
...
I have some MainBook, which have links through LookUp
function with many other books Book1,Book2,... . Those
books have thier own links through LookUp with MainBook
as
well. AnotherBook have links (through LookUp) with those
books (Book1,...) too.

I'm douing the links update from MS Access.
I'm trying to do it by using the following for all these
books:

xlapp.AskToUpdateLinks = False
Set xlbook = xlapp.Workbooks.Open(...)

With xlbook

.UpdateLink Name:=xlbook.LinkSources

End With

Please, advise whether it's enough to have those links
updated.

Thanks in advance.


.

If you have circular links such as you describe, then you would need all the
workbooks open at the same time I would think. This would be the
safest/surest in any event.

--
Regards,
Tom Ogilvy

"Alex" wrote in message
...
Thanks a lot, Tom.
However, in this case, I need to ask you the following
questions:

1. Should all these books be opened during this time?
2. I have a situation when cells A1:A100 from the MainBook
are linked to the cell B1 in Book1,Book2, ... and cell D1
from those Book1,Book2 is linked to some specific cell
from column H of MainBook. Everything is through LookUp.
Will all these links be updated in this case?

Regards,

Alex

-----Original Message-----
There will be no ripple effect, so you would need to open
the workbooks at
the lowest level of a chain of links first and work
upward in a breadth
first manner.

--
Regards,
Tom Ogilvy

"Alex" wrote in
message
...
I have some MainBook, which have links through LookUp
function with many other books Book1,Book2,... . Those
books have thier own links through LookUp with MainBook
as
well. AnotherBook have links (through LookUp) with those
books (Book1,...) too.

I'm douing the links update from MS Access.
I'm trying to do it by using the following for all these
books:

xlapp.AskToUpdateLinks = False
Set xlbook = xlapp.Workbooks.Open(...)

With xlbook

.UpdateLink Name:=xlbook.LinkSources

End With

Please, advise whether it's enough to have those links
updated.

Thanks in advance.


.

Thank you very much again, Tom.

-----Original Message-----
If you have circular links such as you describe, then you
would need all the
workbooks open at the same time I would think. This
would be the
safest/surest in any event.

--
Regards,
Tom Ogilvy

"Alex" wrote in
message
...
Thanks a lot, Tom.
However, in this case, I need to ask you the following
questions:

1. Should all these books be opened during this time?
2. I have a situation when cells A1:A100 from the
MainBook
are linked to the cell B1 in Book1,Book2, ... and cell
D1
from those Book1,Book2 is linked to some specific cell
from column H of MainBook. Everything is through LookUp.
Will all these links be updated in this case?

Regards,

Alex

-----Original Message-----
There will be no ripple effect, so you would need to
open
the workbooks at
the lowest level of a chain of links first and work
upward in a breadth
first manner.

--
Regards,
Tom Ogilvy

"Alex" wrote in
message
...
I have some MainBook, which have links through LookUp
function with many other books Book1,Book2,... .
Those
books have thier own links through LookUp with
MainBook
as
well. AnotherBook have links (through LookUp) with
those
books (Book1,...) too.

I'm douing the links update from MS Access.
I'm trying to do it by using the following for all
these
books:

xlapp.AskToUpdateLinks = False
Set xlbook = xlapp.Workbooks.Open(...)

With xlbook

.UpdateLink Name:=xlbook.LinkSources

End With

Please, advise whether it's enough to have those
links
updated.

Thanks in advance.


.



.