Feb 18 2021 08:56 AM
Feb 18 2021 10:22 AM
Problem
The hyperlink should be kept dynamic - relative to the path of the workbook.
SolutionFollowing formulas: a) = LEFT (CELL (& quot; filename & quot ;; A1); FIND (& quot; [& quot ;; CELL (& quot; filename & quot ;; A1)) - 1) b) = HYPERLINK (A1 & amp; & quot; test1. xls & quot;)
See the file please
Source: https://www.herber.de/mailing/Dynamischer_Hyperlink.htm
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Feb 18 2021 11:58 AM
Feb 19 2021 07:45 AM