Link to home
Start Free TrialLog in
Avatar of Stephen Kairys
Stephen KairysFlag for United States of America

asked on

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)

User generated image
Please advise.
Thank,s,
Steve
Avatar of Flyster
Flyster
Flag of United States of America image

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
Avatar of Stephen Kairys

ASKER

Flyster,
Thank you for your reply.

Where would I paste the above in the dialog box pictured in my original post?
Steve
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")
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
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.
Thanks.  I have my link, per your suggestion, installed in my workbook so I can now use it. :)
Steve
ASKER CERTIFIED SOLUTION
Avatar of Flyster
Flyster
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you. I've stopped serious work for the day but will try tomorrow. I appreciate the help.
-Steve
Flyster, The above worked. Very cool. THANK YOU and Happy Holidays!
Steve
Thanks Steve. Same to you and yours!