Is there a way to update more than one link at a time?

[kiwicanta7]

Hello!

So I am still trying to work out how to maintain links between Excel and PowerPoint, but in the meantime is there a way to update all of the links to the new Excel location at once? Everything works fine once I re-link them manually 1by1, but I have a lot of links and it takes a significant amount of time. Is there a way to link them all to the same new file location? Appreciate any help you may be able to provide!

 

[XLfriend777]

Hi kiwicanta7 - Welcome to the forum. You may be able to use some form of the VBA script below to change links if you are familiar with VBA. Hope this helps you get started.

Sub AddHyperlinkToCell()
    ActiveSheet.Hyperlinks.Add Range("A1"), Address:="https://www.cnn.com"
End Sub