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.
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?- Update:
As we all know, hyperlinks to shared files only work when both files are open. My problem occurs when I open both files via my Windows Explorer shortcut on my PC.
When I use Excel (File #1) to access the directory to open the linked file (File #2), the hyperlink works. What I mean by that is that I have the file path for the linked directory (which houses File #2) written out in the worksheet of File #1. When I click on that text, Excel causes Windows Explorer to open. When I open the file from that window, the hyperlink works.
I don't understand why that works, but if that helps anyone else to understand a setting in Excel or in Windows that is keeping the hyperlink from working otherwise, I'd be interested in understanding.