Changing external file links

I have several financial models that I have linked to an 'assumption control file' so that I can modify key assumptions in all of the models just by changing the data in the assumption control file.

My problem is that now I need to hand off a complete set of the models as well as an assumption control file to a client. If I copy all of the files, the assumption references (links) remain with the assumption control file on my computer. I want the links to change to be to the assumption control file that I have copied for them so that they can do further assumption sensitivity testing.

What is the easiest way to accomplish this? Or do I have to physically go thru cell by cell to change the link location?

Thanks for any help.

Use the menu entry Edit >> Links

Change it once, it applies to all.