Update Hyperlinks Automatically when Folder Name or Location Change

[civram1982]

hi everyone just want to ask about hyperlink if possible that excel will automatically update hyperlink when folder change or location so that i will not link again one by one. my files is in the server the problem is i will move the excel file and change the folder name that are link to to excel. thank you in advance

[cytop]

It's not possible to do it automatically, but you could run something like

Sub z()

    Dim h As Hyperlink
    
    Dim OldPath As String
    Dim NewPath As String
    
    OldPath = "c:\temp\"
    NewPath = "c:\temp1\"
    
    For Each h In ActiveSheet.Hyperlinks
        
        With h
            .Address = Replace(.Address, OldPath, NewPath)
            .TextToDisplay = Replace(.TextToDisplay, OldPath, NewPath, compare:=vbTextCompare)
            '// Add in any other properties you might want to change here
            
        End With
    Next

End Sub

To bulk update hyperlinks. Use whatever method you choose to populate OldPath & NewPath

[civram1982]

thank you for your reply. but my hyperlink is not a formula what i did is right click the cell hyperlink then browse for the file.