automatic updates
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: automatic updates

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    You could also use (From Help File)

    Example

    This example updates all links in the active workbook.

    ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources





    Regards,

    Juan Pablo González
    http://www.juanpg.com

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com