After Excel on my Mac crashed it made an autorecovery, the file reopend but all the linked cells to a network location the link paths have been changed!

Original link:

file:///Users/dirk/Synology_ELTERN/

Changed link:

file:///Users/dirk/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft/

It’s quite frustrating to correct this manually, particularly if you have many hyperlinks

I tried find and replace but that seems not an option at all, as the links cannot be found at all

So I tried VBA for the first time but with no much success either

Sub FixHyperlinks()
    Dim link As Hyperlink
    For Each link In ActiveSheet.Hyperlinks
        link.Address = Replace(link.Address, "file:///Users/dirk/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft/", "file:///Users/dirk/Synology_ELTERN/")
    Next link
End sub

I’m totally new to macros and am really stumbling about in the dark here. Any help/advice would be very much appreciated!

Have you all a very nice weekend and many thanks in advance!