How to update all links to other workbooks

  • Thread starter Thread starter Cresta
  • Start date Start date
C

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
 
Nope.

Excel doesn't keep track of what workbooks are retrieving values from a
workbook.
 
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
 
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.
 
Is there any vba code to do this task?

Dave Peterson said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA code for pasting links -- modifying RDB code for summary workbook 10
Code to loop through the Workbook Links 1
Who is linking to my file? And what files am I linking to? 1
Linking to Password-required-to-open workbooks 2
Workbooks with links to each other 4
Push updates to other workbooks? 10
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
COM addin won't connect when workbook opened via another workbookfrom another instance 3

Back
Top