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.