• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hyperlink

D

Dilip D

New Member
Hi,
Please can you help.
I have a xlsx file called recipes.xls on a network drive and the path is
\\DIGISOL-2BAY\md1-public\Windata\Recipes (Done V)
I would like to get a hperlink in any cell whereby upon clicking it should take me to a file called

500 recipes for bread.xlsx and open it say at cell A14 (for eg) this file is also on network and the

path is:
\\DIGISOL-2BAY\md1-public\Windata\Recipes (Done V)\Xls
I have tried all combinations I think of but to no avail.
However if I map the folder on the network to a drive to a letter say Z I can get it to work and the

path then looks like this:
=HYPERLINK("[z:\windata\Recipes (Done V)\\Xls\500 Recipes for Bread final.xlsx]Sheet1!

a14","French Toast Cheddar Sandwiches ").
I would like not use mapping so what should my formula look like with no mapping involved.
Thanks
Regards
Dilip Dabrai
 
=Hyperlink("\\DIGISOL-2BAY\md1-public\Windata\Recipes (Done V)\Xls\500 recipes for bread.xlsx","500 recipes for bread")
 
Hiya Chirayu,
Your help was great only one problem though I want to go to a specified cell when I click the hyperlink, so I changed the hyperlink slightly to

=Hyperlink("[\\DIGISOL-2BAY\md1-public\Windata\Recipes (Done V)\Xls\500 recipes for bread.xlsx]Sheet1!a24","Gajetas")

I added square brackets with the addition of pointing to cell A24 and changed the text to be displayed to Gajetas but I still Cannot go to the cell A24.
Where am I going wrong.
Thanks
Regards
Dilip Dabrai
 
Hi Chirayu,
I don´t think I have explained myself properly.
Can we talk on skype so I can show the files and explain more clearly. I am based in India and we are 4.5 hrs ahead of GMT please if can give me a date and time suitable to both of us and I will do my best to meet the appointment.
My skype id is itdoc007.
Thanks
Regards
Dilip Dabrai

PS I can send you the file via email as well with detailed explanation If you can give us your email address
 
You must log in or register to reply here.
Back
Top