• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 277
  • 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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