I have an Excel file with cells which contain references to other
files.  When my collegue puts then on a CD and then I copy them to by
folder, the references to the other files still point to the file name
of the CD.  How do I make them point to the copy on my computer?  I
tried opening the file to which the reference is made first, but that
didn't work.

After making a copy of all of the files, in the file with the sources
go to "Edit" -> "Links" -> select the name of one of the files in the
the pop-up window and click "Change Source".  Then select the file on
the in the correct location and click "ok".

Please let me know if you have any additional Qs