Change links on moving to CD or another computer
 

I have a large number of Excel files with links to some common data
files all held in teh same directory.

How do I copy these to a CD in a way that changes the directory
references to reflect the new directory they are in - either on the CD
or when copied to another computer.

Thank you
Rich80105