Forum Discussion
Solved
File name, referenced in a hyperlink, located in a different cell
I would like to create a fixed hyperlink in cell I5 in a worksheet named ABC. I would like this hyperlink to reference cell B5 in a worksheet within a separate directory. This file is named 20210830...
- Thank you. I added a \ to the end of the file path in your example and that worked. Great support! I appreciate the help very much.
=HYPERLINK(ADDRESS&FILENAME)
=HYPERLINK("\\server\directory\"&J11)
To retrieve the value inside the file it needs to be opened to work using the INDIRECT formula
=INDIRECT("'"&ADDRESS&"["&FILENAME&"]Sheet1'!$B$5")
=HYPERLINK("\\server\directory\"&J11,INDIRECT("'"&"\\server\directory\"&"["&J1&"]Sheet1'!$B$5"))
The INDIRECT formula works but the file must be opened.
- I appreciate the response but I am unclear. Do I paste this string into cell I5?
=HYPERLINK("\\server\directory\"&J11,INDIRECT("'"&"\\server\directory\"&"["&J1&"]Sheet1'!$B$5"))
If so, do I remove any of the quotes? It isn't working. Thanks.- Thank you. I added a \ to the end of the file path in your example and that worked. Great support! I appreciate the help very much.