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
XJ
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
XJ