B
BillT
I make an absolute hyperlink (full path). When I 'Save',
it reverts to a relative hyperlink. How do I avoid this?
it reverts to a relative hyperlink. How do I avoid this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David McRitchie
what do you see
Example
Example
and where used
and how created
Example
Example
and where used
and how created
B
BillT
My Excel file sits on server A.
If I make a link to a file/directory on server B by browsing to select the server and file/directory, the link initially appears as a relative link, like
...\..\..\serverB\Lots\D74854
, and I can not make a connection to it.
If instead I edit that link to be an absolute link, like
file:\\serverB\Lots\D74854
then I can make connection to it. HOWEVER, once I 'Save' the excel file and re-open it, the link again appears as a relative link:
...\..\..\serverB\Lots\D74854
When making links to files/directories on the same server as my excel file, this problem doesn't appear (evidently because the relative links are fine within a server). However, I'll probably want to make even these links absolute, so that I can move my Excel file at some later time, and still have ALL my links work.
If I make a link to a file/directory on server B by browsing to select the server and file/directory, the link initially appears as a relative link, like
...\..\..\serverB\Lots\D74854
, and I can not make a connection to it.
If instead I edit that link to be an absolute link, like
file:\\serverB\Lots\D74854
then I can make connection to it. HOWEVER, once I 'Save' the excel file and re-open it, the link again appears as a relative link:
...\..\..\serverB\Lots\D74854
When making links to files/directories on the same server as my excel file, this problem doesn't appear (evidently because the relative links are fine within a server). However, I'll probably want to make even these links absolute, so that I can move my Excel file at some later time, and still have ALL my links work.
David McRitchie said:what do you see
Example
Example
and where used
and how created
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
BillT said:I make an absolute hyperlink (full path). When I 'Save',
it reverts to a relative hyperlink. How do I avoid this?
S
Spork Rhonewood
D
David McRitchie
I'm not on a server, but you might also want to look at two of
Harlan Grove's postings that I found looking for the part of
his answer that I remembered involving hyperlink base: in file, properties:
Since you can't search on "/../" "\\" I searched on
hyperlink.base group:*Excel* author:harlan
http://google.com/groups?threadm=uHCAPOp6BHA.1912@tkmsftngp03
http://groups.google.com/groups?threadm=OjVRpQQ7BHA.2268@tkmsftngp04
and the one you posted can be looked up faster on google groups
http://google.com/[email protected]
Harlan Grove's postings that I found looking for the part of
his answer that I remembered involving hyperlink base: in file, properties:
Since you can't search on "/../" "\\" I searched on
hyperlink.base group:*Excel* author:harlan
http://google.com/groups?threadm=uHCAPOp6BHA.1912@tkmsftngp03
http://groups.google.com/groups?threadm=OjVRpQQ7BHA.2268@tkmsftngp04
and the one you posted can be looked up faster on google groups
http://google.com/[email protected]
B
BillT
Perfect. Thank you.
D
David McRitchie
Thanks for letting us know which link specifically helped you.
T
Tonio
Hello,
I have visited your page and I didn't found how to conserve the absolute
path.
Could you please indicate me how to conserve the absolute path ?
Thanks,
Tonio
I have visited your page and I didn't found how to conserve the absolute
path.
Could you please indicate me how to conserve the absolute path ?
Thanks,
Tonio
David McRitchie said:what do you see
Example
Example
and where used
and how created
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
I make an absolute hyperlink (full path). When I 'Save',
it reverts to a relative hyperlink. How do I avoid this?
D
David McRitchie
Hi Tonio,
Perhaps look at the thread as there is nothing on my site
that relates to this. The terms absolute and relative
hyperlinks were new to me although I use these forms
in HTML all the time, never in Excel. So you will have to
read the newsgroup references. Here is the Google
Groups reference that will get you to the entire thread
starting with were Bill described better what he was looking for.
http://google.com/groups?threadm=C8FAB338-A820-433F-A633-2A73EA21A78F@microsoft.com
Perhaps look at the thread as there is nothing on my site
that relates to this. The terms absolute and relative
hyperlinks were new to me although I use these forms
in HTML all the time, never in Excel. So you will have to
read the newsgroup references. Here is the Google
Groups reference that will get you to the entire thread
starting with were Bill described better what he was looking for.
http://google.com/groups?threadm=C8FAB338-A820-433F-A633-2A73EA21A78F@microsoft.com
T
Tonio
Hi,
Thanks,
Tonio
Thanks,
Tonio
David McRitchie said:Hi Tonio,
Perhaps look at the thread as there is nothing on my site
that relates to this. The terms absolute and relative
hyperlinks were new to me although I use these forms
in HTML all the time, never in Excel. So you will have to
read the newsgroup references. Here is the Google
Groups reference that will get you to the entire thread
starting with were Bill described better what he was looking for.
http://google.com/groups?threadm=C8FAB338-A820-433F-A633-2A73EA21A78F@microsoft.com
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
Tonio said:I have visited your page and I didn't found how to conserve the absolute
path.
Could you please indicate me how to conserve the absolute path ?
T
Tonio
Hi,
The function LIEN_HYPERTEXTE(" "," ") works fine. (I'm french)
Bye,
Tonio
The function LIEN_HYPERTEXTE(" "," ") works fine. (I'm french)
Bye,
Tonio
David McRitchie said:Hi Tonio,
Perhaps look at the thread as there is nothing on my site
that relates to this. The terms absolute and relative
hyperlinks were new to me although I use these forms
in HTML all the time, never in Excel. So you will have to
read the newsgroup references. Here is the Google
Groups reference that will get you to the entire thread
starting with were Bill described better what he was looking for.
http://google.com/groups?threadm=C8FAB338-A820-433F-A633-2A73EA21A78F@microsoft.com
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
Tonio said:I have visited your page and I didn't found how to conserve the absolute
path.
Could you please indicate me how to conserve the absolute path ?