Without knowing what specified directory structure you requested you
users to save the files in, it's hard to tell what the problem is. I
Microsoft Windows (2000 is what I am currently using), if you log in a
a specific user, then your default Desktop directory is located in
directrory specific to the logged in user like this:

'C:\Documents and Settings\-username- \Desktop'

The file directories are specific to the username (My Documents, etc.
that is logged in to the computer. Since each username is different
the link won't work because the filepath that was embedded in the lin
from the computer that you logged into changes from user to user.

If you save the SOURCE file to the root directory 'C:\Temp' _before
you create the link(s) in the destination file, it should be able t
update the link(s) if the user saves the SOURCE file to the roo
'C:\Temp' directory prior to opening the destination file

--
theDud
-----------------------------------------------------------------------
theDude's Profile: http://www.excelforum.com/member.php...fo&userid=1655
View this thread: http://www.excelforum.com/showthread.php?threadid=31402