Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 298
  • Last Modified:

EXCEL 2013 - Link to a Specific Cell in Another Workbook

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
Stephen Kairys
Asked:
Stephen Kairys
  • 5
  • 5
1 Solution
 
FlysterCommented:
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
 
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
Flyster,
Thank you for your reply.

Where would I paste the above in the dialog box pictured in my original post?
Steve
0
 
FlysterCommented:
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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
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
 
FlysterCommented:
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
 
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
Thanks.  I have my link, per your suggestion, installed in my workbook so I can now use it. :)
Steve
0
 
FlysterCommented:
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
 
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
Thank you. I've stopped serious work for the day but will try tomorrow. I appreciate the help.
-Steve
0
 
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
Flyster, The above worked. Very cool. THANK YOU and Happy Holidays!
Steve
0
 
FlysterCommented:
Thanks Steve. Same to you and yours!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now