Excel External link

[guava65]

Is there a way to link a cell in Excel file with another cell in another file without having the full path in the formula?

I want to be able to transfer a set of files to a different machine without having to re-link cells because they have a path related to their formula. Instead of a path, I would like to have the file look in the current directory for the other related files.

I'm sure this is possible but I haven't been able to figure this out.
Mahalo,
cg

 

[JVFriederick]

I'm thinking the trick is to have both files open at the same time, then save both to the "new" location.

I have run across problems with this before, and had to set the working directory in Excel with macro code. If option 1 does not work for you, please let me know and I'll look up and send on the code.