From: "Geo." 

Are you opening the spreadsheet directly from the email or copying it to
your desktop first?

Geo.

"Chris Robinson"  wrote in
message news:3DD3CD8E.4BC8CDB1{at}NOSPAMtotalise.co.uk...
> 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