hatman
Well-known Member
- Joined
- Apr 8, 2005
- Messages
- 2,664
In upgrading from XL2000 to XL2003 I have found a small annoyance in the behavior of manually input hyperlinks... see if anyone else has seen this:
From Windows Explorer, I copy the following address from the Address Bar:
And paste it into a new Hyperlink (Ctrl+k).
When I save the book, the Link field of the Hyperlink changes to:
I understand that Excel just changed my link from an Absolute Reference to a Releative reference... fine. But when I follow the link, the resulting Windoes Explorere window has the following string in the Address Bar:
Notice that the direction of the slashes reverses itself in the section that represents the Reletive portion of the address from the hyperlink. fine, it gets me to the coorect address, but when I use the Folder Up button in Widwos Eplorrer, rather than navigating Up a SINGLE level, it moves up Two. Fine, I can navigate back down a level... it's annoying, but get downright confusing in the floowing example:
Where I end up FIVE levels higher than I started... if I'm not paying close attaention, I get completely lost... not to mention my other users who are less attentive than myself.
I am passingly familiar with the difference between Local, Global, Absolute and Relative Paths... and I understand that there is some sort of hand-waving going on here (pay no attention to the man behind the curtain). And I seem to remeber an erlier version of Excel where they had a check box in the Hyperlink Dialog Window that allowed the user to make a distinction bewteen Local and Globaal paths... that seems to have disappeared and been replaced with an automated parsing routine. But when all is said and done, I by no means an expert on what is going on here. Does anyone have any insights to help me?
From Windows Explorer, I copy the following address from the Address Bar:
Code:
\\hswlnfs1\homes\proceng\wip\test_procs\wpoga\oga\H2_ORU\pftp_wpoga_sv826716CAnd paste it into a new Hyperlink (Ctrl+k).
When I save the book, the Link field of the Hyperlink changes to:
Code:
../../H2_ORU/pftp_wpoga_sv826716CI understand that Excel just changed my link from an Absolute Reference to a Releative reference... fine. But when I follow the link, the resulting Windoes Explorere window has the following string in the Address Bar:
Code:
\\hswlnfs1\homes\proceng\wip\test_procs\wpoga\oga\H2_ORU/pftp_wpoga_sv826716CNotice that the direction of the slashes reverses itself in the section that represents the Reletive portion of the address from the hyperlink. fine, it gets me to the coorect address, but when I use the Folder Up button in Widwos Eplorrer, rather than navigating Up a SINGLE level, it moves up Two. Fine, I can navigate back down a level... it's annoying, but get downright confusing in the floowing example:
Code:
\\hswlnfs1\homes\proceng\wip\opsheets/ssf/oga/cell_stack/production_cell_stack/SV825597_1r2Where I end up FIVE levels higher than I started... if I'm not paying close attaention, I get completely lost... not to mention my other users who are less attentive than myself.
I am passingly familiar with the difference between Local, Global, Absolute and Relative Paths... and I understand that there is some sort of hand-waving going on here (pay no attention to the man behind the curtain). And I seem to remeber an erlier version of Excel where they had a check box in the Hyperlink Dialog Window that allowed the user to make a distinction bewteen Local and Globaal paths... that seems to have disappeared and been replaced with an automated parsing routine. But when all is said and done, I by no means an expert on what is going on here. Does anyone have any insights to help me?
