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.
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.
=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.
- Any timemy friend. Please just hit the Like Button and flag it as solved.
- Ok, now this is odd. Maybe you can help.
2 days ago, I created these hyperlinks on file #1. Yesterday in the morning I opened file #1 and file #2 and the hyperlink directing to file #2 was broken. The same afternoon I opened the two files and the hyperlink worked. ???
What outside influences could affect file #1's ability to access data in file #2? Both files are located within the same parent directory on a shared drive. It wouldn't be a security policy since it worked twice and failed to work twice. Maybe add-ons?