EXCEL 2013 - Link to a Specific Cell in Another Workbook

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

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

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!