Solved

EXCEL 2013 - Link to a Specific Cell in Another Workbook

Posted on 2014-12-23
10
150 Views
Last Modified: 2014-12-24
Hello everyone, and Happy Holidays.

I am trying to insert a hyperlink to a specific cell in another workbook.  While I know how to insert a hyperlink to a particular workbook (per the screen below), I can't find how to reference a particular cell (e.g. A47)

Excel - Insert Hyperlink Dialog Box
Please advise.
Thank,s,
Steve
0
Comment
Question by:Stephen Kairys
  • 5
  • 5
10 Comments
 
LVL 22

Expert Comment

by:Flyster
ID: 40515352
The syntax for that would be:

=HYPERLINK("[Path/Workbook Name]SheetName!Cell", Friendly Name)

Something like:

=HYPERLINK("[C://MyFolder/TargetWorkbook.xlsx]Sheet1!A47", "Click here for Cell A47")

Flyster
0
 
LVL 4

Author Comment

by:Stephen Kairys
ID: 40515520
Flyster,
Thank you for your reply.

Where would I paste the above in the dialog box pictured in my original post?
Steve
0
 
LVL 22

Expert Comment

by:Flyster
ID: 40515710
Hi Steve,

I don't think you can enter that from the Hyperlink Wizard. Basically what the Wizard does is create the code that I provided. I have to make one slight correction. Those should be forward slashes:

=HYPERLINK("[C:\MyFolder\TargetWorkbook.xlsx]Sheet1!A47", "Click here for Cell A47")
0
 
LVL 4

Author Comment

by:Stephen Kairys
ID: 40515739
OK, so you're saying I should put the text below in the cell, like I would for the formula. Makes sense.

In fact, it worked!  I hope you don't mind if I keep the question open in case anyone knows how to do the above from the wizard. Be assured though that if you idea works, that I will be rewarding you points and a grade of A.

Thanks,
Steve
0
 
LVL 22

Expert Comment

by:Flyster
ID: 40515795
No problem. I'm kind of curious myself and will be trying a few things. I don't believe it can be done because it does not give you the edit hyperlink choice when you right-click or ctrl+K.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 4

Author Comment

by:Stephen Kairys
ID: 40515894
Thanks.  I have my link, per your suggestion, installed in my workbook so I can now use it. :)
Steve
0
 
LVL 22

Accepted Solution

by:
Flyster earned 500 total points
ID: 40515910
OK, I figured it out. In the address section, enter the path, followed by the pound sign, followed by the Sheet Name and cell. Sample:

C:\YourFolder\YourWorkbook.xlsx#Sheet1!A47
0
 
LVL 4

Author Comment

by:Stephen Kairys
ID: 40515912
Thank you. I've stopped serious work for the day but will try tomorrow. I appreciate the help.
-Steve
0
 
LVL 4

Author Closing Comment

by:Stephen Kairys
ID: 40516693
Flyster, The above worked. Very cool. THANK YOU and Happy Holidays!
Steve
0
 
LVL 22

Expert Comment

by:Flyster
ID: 40516785
Thanks Steve. Same to you and yours!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now