From: "Geo." 

It's working like if the user emailed you a shortcut.

Geo.

"Chris Robinson"  wrote in
message news:3DD4B55A.4EA57B8D{at}NOSPAMtotalise.co.uk...
> Directly from the e-mail.  I just copied it to the desktop though and now
it
> tries to open:
>
> "X:\Documents And Settings\User\Desktop\Linked Workbook.xls"
>
> It's assuming the linked file is always in the same place relative to the
> linking file.
>
> I've also tried going into Excel's options (TOOLS>OPTIONS) and selecting
the
> "Web Options" on the "General" tab.  This gives
you the option to "update
links
> on save" which was checked by default.  I unchecked this thinking that it
meant
> the links would be updated next time the file was opened/ altered (i.e.
from the
> e-mail), but this made no difference at all ?
>
> Chris.
>
> "Geo." wrote:
>
> > 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