Hyperlink in Excel won't open

TrixieLee

Estimable
Jan 22, 2015
2
0
4,510
0
Hello, I'm trying to use a hyperlink in my document to a cell in a separate sheet in the same Worksheet. I have finally figured out the formula but when I click on the link it says it can't open it. Any ideas why? Here's my Hyperlink text:
=HYPERLINK("['toxicology summary.xlsx']Test_Sheet!A1",'Test Sheet'!A1)
any ideas/help would be appreciated.
 

TrixieLee

Estimable
Jan 22, 2015
2
0
4,510
0
I've figured it out. In case anyone else needs this help... because I'm on a network I couldn't just name the sheet with the sheet name, I would have had to include the network path to it as well I believe. So what I did instead to get around this was:
- named the range on the Test Sheet
- used the Insert Hyperlink option,
- chose "Place in this Document"
- chose the Named section I had just created

and voila after saving the link works!
 
Thread starter Similar threads Forum Replies Date
N Apps General Discussion 2
A Apps General Discussion 1
V Apps General Discussion 2
Z Apps General Discussion 4
I Apps General Discussion 1
XGamer_BiH Apps General Discussion 1
G Apps General Discussion 1
S Apps General Discussion 1
V Apps General Discussion 8
P Apps General Discussion 14
C Apps General Discussion 1
D Apps General Discussion 1
J Apps General Discussion 6
G Apps General Discussion 1
viveknayyar007 Apps General Discussion 0
viveknayyar007 Apps General Discussion 0
BackInBlack47 Apps General Discussion 1
A Apps General Discussion 1
A Apps General Discussion 1
jnkweaver Apps General Discussion 5

ASK THE COMMUNITY