Solved

EXCEL 2013 - Link to a Specific Cell in Another Workbook

Posted on 2014-12-23
10
151 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
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 
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
 
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

806 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