Feb 18 2021 08:56 AM
Feb 18 2021 10:22 AM
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
I would be happy to know if I could help.
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.