How to bulk change all hyperlinks in excel?

Question

excel

Hi all!
Such situation. There is such file:

And everywhere on hyperlinks the word parsing/Licenses/Details/ and the value is written.

Now I need to change the word parsing to another word there.
How can you do it everywhere?
Help.
There are more than 20 thousand lines.

Answer 1

Alt+F11

Sub FixLinks()
    Dim hLink As Hyperlink
    Dim sOld As String
    Dim sNew As String

    sOld = "http://parsing"
    sNew = "http://newsite"
    
    For Each hLink In ActiveSheet.Hyperlinks
        hLink.Address = Replace(hLink.Address, sOld, sNew)
    Next hLink
End Sub

execute