There used to be an option when creating a hyperlink on a shape in old
versions of excel where you could select it to be an absolute path,
but seems to have vanished from new versions. Or has it? Please advise
if there is a way to maintain absolute paths, without resorting to
macros. Need this to create simple web pages with flow charts that
have hyperlinks. Thanks, Alex |
Request for Question Clarification by
bobbie7-ga
on
10 Jan 2006 08:02 PST
Enex,
I tried this in Excel 2003 and it worked.
To create a hyperlink on a shape.
Select the shape you want to turn into a hyperlink.
Choose Insert, Hyperlink to open the Insert Hyperlink dialog box
Locate and select the file that you want to open when the hyperlink is clicked.
(You can also enter a URL in the address space below to hyperlink to a webpage)
Click OK to create the hyperlink and close the hyperlink dialog box.
Please let me know if it works for you.
Thanks, Bobbie7
|
Clarification of Question by
enex-ga
on
10 Jan 2006 10:14 PST
Hi, thanks for your answer. I do already know how to add a hyperlink
in this way, which seems to work in some instances, such as when you
tried.
The problem I get is with absolute hyperlinks to office network
locations, and using Excel 2000, e.g.
\\asdfgh1234\server_name\path\...filename.ext These links sometimes
get altered by Excel 2000, when saving, to become relative
..\filename.ext
I need to understand exactly how to avoid this problem in Excel 2000
using absolute links to network locations. The problem is well posted
on google groups but i didn;t find any answers there. Probably
microsoft paper exists on this 'bug'
Cheers
|
Request for Question Clarification by
hammer-ga
on
10 Jan 2006 14:32 PST
Enex,
Does this help?
http://exceltips.vitalnews.com/Pages/T0797_Inserting_Hyperlinks.html
Look at the section at the bottom about setting the Hyperlink Base for
the document.
- Hammer
|
