From: Chris Robinson 


--------------617EA8C0C7D65FAD0385341A
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I am using the UNC path in the link though - that's the odd part.  I see
what you mean though.  The hyperlink chnages based on the location you open
the linking file from - that's the problem though :o(

I have given the guy a work around for the minute which is to link to the
remote location of the file rather than include it as an attachment.  This
means the user opens the original copy of the file and so the links are all
OK.

That said, it's still puzzling me.  I can see the logic behind it as if you
were to move an entire share to a new server for example, any links in your
workbooks would automatically be updated as they were relative to each
other.

Chris.

Rich wrote:

>    I suspect the linking file is being opened as X:\sometime hence the
> relative link.  I'd have expected the drive relative path to be
> replaced with a UNC path. Rich
>
>      "Chris Robinson"  wrote in
>      message news:3DD3AD5B.BDDFF09{at}NOSPAMtotalise.co.uk...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.
>

--------------617EA8C0C7D65FAD0385341A
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit




I am using the UNC path in the link though - that's the odd part. 
I see what you mean though.  The hyperlink chnages based on the
location you open the linking file from - that's the problem though :o(
I have given the guy a work around for the minute which is to link to
the remote location of the file rather than include it as an
attachment.  This means the user opens the original copy of the
file and so the links are all OK.
That said, it's still puzzling me.  I can see the logic behind
it as if you were to move an entire share to a new server for example, any
links in your workbooks would automatically be updated as they were
relative to each other.
Chris.
Rich wrote:

  
I suspect the linking file is being opened as X:\sometime hence the
relative link.  I'd have expected the drive relative path to be
replaced with a UNC path. Rich 
"Chris
Robinson" <c.robinson{at}NOSPA">mailto:c.robinson{at}NOSPAMtotalise.co.uk">c.robinson{at}NOSPA
Mtotalise.co.uk>
wrote in message news:3DD3
AD5B.BDDFF09{at}NOSPAMtotalise.co.uk...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.





--------------617EA8C0C7D65FAD0385341A--

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