I have the Edit Links button on the words QAT but updating like 40 Links each time I do a report is highly tedious and defeats the purpose. It would be easier just to hand modify the data in the actual report.

I tried using your VB code but say if I cut the Word and Excel together and paste them into a new folder each time it tries to update the links they are broken. Do I need to run the code or something? This is all new to me. I am Using Word 2013 if that makes any difference. Is it ok to rename the Module to Link_Fix?

Also the updating process is very slow when opening the file. Would you suggest only have one link from the excel to the word and then making an OLE Link if the data repeats in the document? Would that make it faster?