From: Ellen K. 

Ya know what, I missed the part about the path getting  ...mail
attachments... appended to the front.   This is kinda dumb, must happen
all the time, gotta be a workaround somewhere.

On Thu, 14 Nov 2002 16:21:34 +0000, Chris Robinson
 wrote in message
:

>I did :
>
>>I've tried to put the destination in quotation marks but this doesn't
>
>I've tried using the full path on it's own and in quotes.  When you put it
>in quotes the hyperlink then tries to open:
>
>x:\mail_attachements\"\\server\share\directory\LinkedFile.xls"
>
>Very odd....
>
>Thanks for the suggestion though :o)
>
>Chris.
>
>"Ellen K." wrote:
>
>> What if you use the full path, i.e. in your example,
>> "\\server\share\directory\LinkedFile.xls"?
>>
>> Also, always use the real machine name, not the mapped drive letter.
>>
>> On Thu, 14 Nov 2002 14:04:12 +0000, Chris Robinson
>>  wrote in message
>> :
>>
>> >All,
>> >
>> >I'm sure I've come across this problem before but can't seem to figure
>> >it out now.  The problem is with Excel (2000).  When you create a
>> >spreadsheet you can insert a hyperlink into a cell (as I'm sure most of
>> >you know).  This works fine when you run the spreadsheet from the
>> >original location but the hyperlink adjusts itself when the spreadsheet
>> >is moved elsewhere.
>> >
>> >One of our users sent an e-mail with a spreadsheet attached.  The
>> >spreadsheet (located on
"\\server\share\directory\LinkingFile.xls", for
>> >example) had a hyperlink to a file "LinkedFile.xls"
in the same
>> >directory - this works fine on his PC as he runs the spreadsheet from
>> >it's location on the server.  However, when he e-mails it to anyone the
>> >link now points to
"x:\mail_attachements\LinkedFile.xls" - i.e. Excel
>> >appears to be creating a relative link to the file and not an absolute
>> >one (i.e. hyperlink remains the same regardless of the location of the
>> >linking file).
>> >
>> >I've tried to put the destination in quotation marks but this doesn't
>> >help.  I've had a look on google and I can't seem to find anything more
>> >on this - anyone got any ideas?
>> >
>> >Thanks in advance,
>> >Chris.

--- BBBS/NT v4.01 Flag-4