Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    refresh link to many sheets (2000 sr 1)

    I have i wbook with sheet FOGLIO1 and in this sheet have many link (with the tipical "!") with other sheet saved on server dir...
    When i open the princiapl wbook linked with other sheet appera the tipical window "YOU WANT TO REFRESH THE LINK" ... ecc

    Is possible in the event Private Sub Workbook_Open() of pricipal wbbok autoamticly refresh all link without to appera the window fro refresh?
    Hope understand me..

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: refresh link to many sheets (2000 sr 1)

    You don't need code for this.
    Select Tools | Options...
    Activate the Edit tab.
    Clear the check box 'Ask to update automatic links'.
    Click OK.
    Next time you open the workbook, you won't be prompted any more.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: refresh link to many sheets (2000 sr 1)

    If you do want VBA code, I found this: <A target="_blank" HREF="http://www.ozgrid.com/VBA/update-links.htm">Update Links in Excel
    </A>

    Opening Workbook via VBA Code

    If you are using Excel VBA to open the Workbook the problem can be addressed in the Workbook Open Method.

    Sub OpenUpdate()
    Workbooks.Open FileNmae:= _
    "C:My DocumentsLinkedBook.xls", UpdateLinks:=xlUpdateLinksAlways
    End Sub

    Sub OpenDontUpdate()
    Workbooks.Open FileNmae:= _
    "C:My DocumentsLinkedBook.xls", UpdateLinks:=xlUpdateLinksNever
    End Sub

    Sub OpenUpdateLinksPerSettings()
    Workbooks.Open FileNmae:= _
    "C:My DocumentsLinkedBook.xls", UpdateLinks:=xlUpdateLinksUserSetting
    End Sub
    Regards,
    Rudi

  4. #4
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: refresh link to many sheets (2000 sr 1)

    Nice!!!! work, perfect.

  5. #5
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: refresh link to many sheets (2000 sr 1)

    Tks, good link and suggestion.
    Sal.

Posting Permissions

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