Excel. Create a hyperlink from one excel to another.

Grimmie

Honorable
Jan 7, 2014
1
0
10,510
0
Hi, I would really appreciate your help.

So, the problem is that when excel creates a link to a certain workbook, it uses the absolute path (C:/program files/something_I_want.xlsx), but if the target is moved to another folder the hyperlink doesn't work anymore. I do realize that this is pretty straight forward, but I'm looking for a way to create permanent links to another document, without creating the path. Just something like:
PRESS ME --> FILE_which_is_anywhere.xlsx

Thanks in advance
 
There is no way for Excel to know that the file was moved somewhere else. Imagine you copy your file to a USB key, then go to another computer. How you would like the link to look like?

So, your options are: Don't move the target file, use relative links (I think you can edit them to be relative), or use e.g. data-base for it (if that file contains an actula database)
 
Thread starter Similar threads Forum Replies Date
B Apps General Discussion 2
N Apps General Discussion 1
S Apps General Discussion 5
N Apps General Discussion 2
L Apps General Discussion 5
B Apps General Discussion 4
K Apps General Discussion 1
R Apps General Discussion 1
7 Apps General Discussion 37
J Apps General Discussion 11
E Apps General Discussion 15
H Apps General Discussion 13
P Apps General Discussion 5
T Apps General Discussion 2
G Apps General Discussion 1
L Apps General Discussion 6
K Apps General Discussion 0
A Apps General Discussion 1
S Apps General Discussion 1
K Apps General Discussion 3

ASK THE COMMUNITY