automatic updates

[xj]

Hi, need you helps on automatic links updates between files.
Workbook a.xls contains sheets("b1"), Sheets("c1")
Workbook b.xls contains sheets("b1"), Sheets("b2")
Workbook c.xls contains sheets("c1"), Sheets("c2")

in a.xls, sheets("b1")'s source is sheets("b1") in b.xls. Same with sheets("c1").

These 3 workbooks are in three different networked computers. b.xls and c.xls updates frequently. How can i make a.xls automatically changes with the changes of b.xls and c.xls.

Thx

[Juan Pablo González]

This is just an example.

It would update all links (And Pivot Tables if you have any) each time ANY sheet calculates (Which could make it *just a little* slow)

Private Sub Workbook_SheetCalculate(ByVal Sh As Object)

ThisWorkbook.RefreshAll

End Sub

It goes in the Workbook Module.

[Juan Pablo González]

You could also use (From Help File)

Example

This example updates all links in the active workbook.



ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources