Solved

EXCEL 2013 - Link to a Specific Cell in Another Workbook

Posted on 2014-12-23
10
183 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

713 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