Saving hyperlinks that connect multiple servers

[Guest]

I am currently working with two seperate servers.
The first server is the "Q" server, and it is from this spreadsheet that I
hyperlink to additional spreadsheets also found on the "Q" Server.
Essentially this spreadsheet is a template.
After the template is specified to each project, it is saved on the "V"
server. After it is saved, the hyperlink is no longer operational.
Do you know how to create a hyperlink that can be saved on multiple servers
while still retaining its original address?

 

[Dave Peterson]

First, I'd refer to those network folders by the UNC paths
(\\server\sharename\folder\file.ext) instead of using mapped drive letters.

========

Maybe you could drop the Insert|Hyperlink style of hyperlinks and replace them
with by using the =hyperlink() worksheet function.

======
I'm not sure if this will work with your hyperlinks, but a few people have said
that this has resolved the problem for them:

File|Properties|Summary Tab|Hyperlink Base
change it to C:\
(something that's always available)

 

[Guest]

i have had this similar problem before. so i assigned the hyperlinks to a
custom button. this way they are always available from my toolbar no matter
what document you have open. hope this helps.

 

[Guest]

What is a cutom button?

i have had this similar problem before. so i assigned the hyperlinks to a
custom button. this way they are always available from my toolbar no matter
what document you have open. hope this helps.

 

[Bob I]

custom button. R-click Toolbar area, Customize, Commands, scroll down to
Macros and click, see Custom button in right pane, drag to toolbars,
drop, r-click and pick hyperlink.