How to update all links to other workbooks
 

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

How to update all links to other workbooks
 

Nope.

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

Cresta wrote:

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

How to update all links to other workbooks
 

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" wrote:

Nope.

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

Cresta wrote:

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

How to update all links to other workbooks
 

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 wrote:

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" wrote:

Nope.

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

Cresta wrote:

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


--

Dave Peterson

How to update all links to other workbooks
 

Is there any vba code to do this task?

"Dave Peterson" wrote:

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 wrote:

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" wrote:

Nope.

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

Cresta wrote:

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


--

Dave Peterson

How to update all links to other workbooks
 

Look at VBA's help for UpdateLink.

You'll see a one liner.

Cresta wrote:

Is there any vba code to do this task?

"Dave Peterson" wrote:

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 wrote:

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" wrote:

Nope.

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

Cresta wrote:

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


--

Dave Peterson


--

Dave Peterson

How to update all links to other workbooks
 

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





"Dave Peterson" wrote:

Look at VBA's help for UpdateLink.

You'll see a one liner.

Cresta wrote:

Is there any vba code to do this task?

"Dave Peterson" wrote:

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 wrote:

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" wrote:

Nope.

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

Cresta wrote:

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


--

Dave Peterson


--

Dave Peterson