Changing source file using paste link

Hi,

I feel like there should be a really easy answer to this but I just can't work out how to do it!

I've used the paste link function to copy numbers across from excel to word. I've since saved a new copy of my excel document but the word document is still linked to the previous excel document. Therefore I'm trying to update the source file from exceldoc v1 to excel doc v2.

I can see that within the 'Links' window there's the option to change source and I can change the source for each link individually but not all of them at the same time. If I select all my links and click 'change source' I have to select the excel doc v2 again and again, once for each link. I have hundreds of links so can't do this individually for every one. Surely there's a workaround for this?

Thanks!