Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
links update
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
links update
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
links update
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. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
links update
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. . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
links update
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. . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update links | Excel Discussion (Misc queries) | |||
update links | Excel Discussion (Misc queries) | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Update links | Excel Discussion (Misc queries) | |||
can't update links...can't find links | Excel Discussion (Misc queries) |