Solved

EXCEL 2013 - Link to a Specific Cell in Another Workbook

Posted on 2014-12-23
10
209 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

632 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