Hello,

will try to explain this as best as possible.

Basically I have a Word Doc that needs to be a template and an Excel Doc that is also a template.
In the Word doc I have links to the Excel doc so that when data is updated in the excel doc, it auto updates in the word doc.
my dilemma is I need to use these templates many times and the excel doc will therefore be renamed and the links will no longer work. I need a macro (im assuming) in word that i can use that will auto update all the links to the new excel doc.
At the moment I manually have to change each link to be updated, i need a macro that will do it all at once.
I have attached example docs but there will be many more links in my actual files that need to be updated, not just the 3. which is why i cant do it manually

thanks

Book3.xlsxDoc2.docx