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 (Cprogram 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
So, the problem is that when excel creates a link to a certain workbook, it uses the absolute path (Cprogram 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