Stephen Kairys
asked on
EXCEL 2013 - Link to a Specific Cell in Another Workbook
ASKER
Flyster,
Thank you for your reply.
Where would I paste the above in the dialog box pictured in my original post?
Steve
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\T argetWorkb ook.xlsx]S heet1!A47" , "Click here for Cell A47")
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\T
ASKER
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
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.
ASKER
Thanks. I have my link, per your suggestion, installed in my workbook so I can now use it. :)
Steve
Steve
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you. I've stopped serious work for the day but will try tomorrow. I appreciate the help.
-Steve
-Steve
ASKER
Flyster, The above worked. Very cool. THANK YOU and Happy Holidays!
Steve
Steve
Thanks Steve. Same to you and yours!
=HYPERLINK("[Path/Workbook
Something like:
=HYPERLINK("[C://MyFolder/
Flyster