How to update all links to other workbooks

[Cresta]

Hello

I need to go down the list of workbooks linked to this workbook and update
each one. Is there a simple for-next loop to do this?

Thanks

 

[Dave Peterson]

Nope.

Excel doesn't keep track of what workbooks are retrieving values from a
workbook.

 

[Cresta]

Hello Dave
I'm not sure I explained my quiery very well.

When you go to Data, Edit Links, a list of the workbooks linked to this
workbook are displayed on a form which you can select Update link to update
the links you have highlighted.

Is there any code to loop through this list and update each one.

Thanks

 

[Dave Peterson]

Ahh.

You want to update all the links in this workbook.

Select the first source and ctrl-click on the rest (or click on the top and
shift-click on the bottom).

It works the same way as in Windows Explorer.

 

[Cresta]

Is there any vba code to do this task?

Ahh.

You want to update all the links in this workbook.

Select the first source and ctrl-click on the rest (or click on the top and
shift-click on the bottom).

It works the same way as in Windows Explorer.

 

[Dave Peterson]

Look at VBA's help for UpdateLink.

You'll see a one liner.

Is there any vba code to do this task?

 

[Cresta]

Thanks for pointing me in the right direction. Got it sorted.