From: "Rich" 

This is a multi-part message in MIME format.

------=_NextPart_000_0093_01C28BE2.3FA2F870
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

   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.

------=_NextPart_000_0093_01C28BE2.3FA2F870
Content-Type: text/html;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








   I suspect
the linking file =
is being=20
opened as X:\sometime hence the relative link.  I'd have expected
= the drive=20
relative path to be replaced with a UNC path.
 
Rich
 

  "Chris Robinson" <c.robinson{at}NOSPAMtotalise=">mailto:c.robinson{at}NOSPAMtotalise.co.uk">c.robinson{at}NOSPAMtotalise=
.co.uk>=20
  wrote in message news:3DD3AD5B.BDDFF09=
{at}NOSPAMtotalise.co.uk...All,I'm=20
  sure I've come across this problem before but can't seem to =
figureit out=20
  now.  The problem is with Excel (2000).  When you create=20
  aspreadsheet you can insert a hyperlink into a cell (as I'm sure =
most=20
  ofyou know).  This works fine when you run the spreadsheet =
from=20
  theoriginal location but the hyperlink adjusts itself when the=20
  spreadsheetis moved elsewhere.One of our
users sent an =
e-mail with=20
  a spreadsheet attached.  Thespreadsheet (located on
"file://\\server\share\directory\LinkingFile.xls">\\server\share\d=
irectory\LinkingFile.xls",=20
  forexample) had a hyperlink to a file
"LinkedFile.xls" in the=20
  samedirectory - this works fine on his PC as he runs the =
spreadsheet=20
  fromit's location on the server.  However, when he e-mails it =
to=20
  anyone thelink now points to
"x:\mail_attachements\LinkedFile.xls" =
- i.e.=20
  Excelappears to be creating a relative link to the file and not an =

  absoluteone (i.e. hyperlink remains the same regardless of the =
location of=20
  thelinking file).I've tried to put the
destination in =
quotation=20
  marks but this doesn'thelp.  I've had a look on google and I =
can't=20
  seem to find anything moreon this - anyone got any =
ideas?Thanks in=20
  advance,Chris.

------=_NextPart_000_0093_01C28BE2.3FA2F870--

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