Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic hyperlinks not working
Hi,
I have a excel which stores URL and its short description. I need to have a cell in other excel to have the "short description" from first excel and when I click on that it should go to URL given in first excel. I used farmula in cell of second excel like following: =HYPERLINK('\\abc\[excel1.xls]sheet 1'!$G$7,'\\abc\[excel1.xls]sheet 1'!$F$7) This works only when first excel is open. When I close the first excel it has correct URL value and description but when clicked it doesnt take to the URL. Do you know any way to get around this issue? Thanks, Rohan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic hyperlinks not working
besides creating a permanent hyperlink or bringing the data into the second
workbook? No. -- Regards, Tom Ogilvy "Rohan" wrote: Hi, I have a excel which stores URL and its short description. I need to have a cell in other excel to have the "short description" from first excel and when I click on that it should go to URL given in first excel. I used farmula in cell of second excel like following: =HYPERLINK('\\abc\[excel1.xls]sheet 1'!$G$7,'\\abc\[excel1.xls]sheet 1'!$F$7) This works only when first excel is open. When I close the first excel it has correct URL value and description but when clicked it doesnt take to the URL. Do you know any way to get around this issue? Thanks, Rohan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic hyperlinks not working
Hi Tom, thanks for looking into this.
I would not prefer creating permanant hyperlinks since these will be dynamic and they will keep changing. And yes we can bring data into second excel. In this case what would be the best way to get this working? Is there any function that can be triggered by single click and that would open up the address given in first excel? Thanks Much, Rohan Tom Ogilvy wrote: besides creating a permanent hyperlink or bringing the data into the second workbook? No. -- Regards, Tom Ogilvy "Rohan" wrote: Hi, I have a excel which stores URL and its short description. I need to have a cell in other excel to have the "short description" from first excel and when I click on that it should go to URL given in first excel. I used farmula in cell of second excel like following: =HYPERLINK('\\abc\[excel1.xls]sheet 1'!$G$7,'\\abc\[excel1.xls]sheet 1'!$F$7) This works only when first excel is open. When I close the first excel it has correct URL value and description but when clicked it doesnt take to the URL. Do you know any way to get around this issue? Thanks, Rohan |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic hyperlinks not working
do it work if you just do
=\\abc\[excel1.xls]sheet 1'!$G$7 while excel1.xls is open, then when the Excel1.xls is then closed does it still work. If so, then you can do that in book2 for the links and the descriptions, then use you hyperlink formulas to refer to these cells. -- Regards, Tom Ogilvy "Rohan" wrote: Hi Tom, thanks for looking into this. I would not prefer creating permanant hyperlinks since these will be dynamic and they will keep changing. And yes we can bring data into second excel. In this case what would be the best way to get this working? Is there any function that can be triggered by single click and that would open up the address given in first excel? Thanks Much, Rohan Tom Ogilvy wrote: besides creating a permanent hyperlink or bringing the data into the second workbook? No. -- Regards, Tom Ogilvy "Rohan" wrote: Hi, I have a excel which stores URL and its short description. I need to have a cell in other excel to have the "short description" from first excel and when I click on that it should go to URL given in first excel. I used farmula in cell of second excel like following: =HYPERLINK('\\abc\[excel1.xls]sheet 1'!$G$7,'\\abc\[excel1.xls]sheet 1'!$F$7) This works only when first excel is open. When I close the first excel it has correct URL value and description but when clicked it doesnt take to the URL. Do you know any way to get around this issue? Thanks, Rohan |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic hyperlinks not working
yep, it is working now...
Thank you very much! Rohan Tom Ogilvy wrote: do it work if you just do =\\abc\[excel1.xls]sheet 1'!$G$7 while excel1.xls is open, then when the Excel1.xls is then closed does it still work. If so, then you can do that in book2 for the links and the descriptions, then use you hyperlink formulas to refer to these cells. -- Regards, Tom Ogilvy "Rohan" wrote: Hi Tom, thanks for looking into this. I would not prefer creating permanant hyperlinks since these will be dynamic and they will keep changing. And yes we can bring data into second excel. In this case what would be the best way to get this working? Is there any function that can be triggered by single click and that would open up the address given in first excel? Thanks Much, Rohan Tom Ogilvy wrote: besides creating a permanent hyperlink or bringing the data into the second workbook? No. -- Regards, Tom Ogilvy "Rohan" wrote: Hi, I have a excel which stores URL and its short description. I need to have a cell in other excel to have the "short description" from first excel and when I click on that it should go to URL given in first excel. I used farmula in cell of second excel like following: =HYPERLINK('\\abc\[excel1.xls]sheet 1'!$G$7,'\\abc\[excel1.xls]sheet 1'!$F$7) This works only when first excel is open. When I close the first excel it has correct URL value and description but when clicked it doesnt take to the URL. Do you know any way to get around this issue? Thanks, Rohan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Hyperlinks | Excel Worksheet Functions | |||
Dynamic hyperlinks | Excel Discussion (Misc queries) | |||
Dynamic hyperlinks problem | Excel Worksheet Functions | |||
Dynamic Hyperlinks (URL) problem in Excel | Excel Programming |