Update multiple links at once from Microsoft excel macro enabled into word 2016

Occasional Contributor

Hi Team,


Need help in updating multiple links which are refrencing Macro Enabled Excel 2016 in word 2016. As part of document migration to SharePoint Online, we have link established documents. Post- migration we need to establish the broken links between the documents in SharePoint Online.


One way is map documents to local drive and open word documents and update each link in "Edit Links" section maually by clicking on "Change Source". But there are more than 100 links that needs to be updated.


So please help us in understanding on how to establish the multiple broken links in one go. Your help is greatly appriciated.




1 Reply

Sadly, I don't have a solution but wanted to bump this request since I have the exact same question/problem.  Any experts out there?