From: Ellen K. 

I think "update links on save" means update the DATA in linked
spreadsheets.

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