From: Chris Robinson 


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

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.
> >

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



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"
<c.robinson{at}NOSPAMtotalise.co.uk> wrote in message
news:3DD3CD8E.4BC8CDB
1{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
> > <c.robinson{at}NOSPAMtotalise.co.uk> wrote in message
> > <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.
>


--------------C43E08A8DB89C0758153D031--

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