From: Chris Robinson 

No, I'm just using "X" to refer to any drive letter (in this case
the "C" drive).

Chris.

"Ellen K." wrote:

> Do you have a drive you're sharing as "X"?
>
> On Fri, 15 Nov 2002 08:50:34 +0000, Chris Robinson
>  wrote in message
> :
>
> >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