Dynamic hyperlinks not working

[Rohan]

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

 

[Tom Ogilvy]

besides creating a permanent hyperlink or bringing the data into the second
workbook? No.

 

[Rohan]

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

besides creating a permanent hyperlink or bringing the data into the second
workbook? No.

--
Regards,
Tom Ogilvy

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

 

[Tom Ogilvy]

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

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

besides creating a permanent hyperlink or bringing the data into the second
workbook? No.

--
Regards,
Tom Ogilvy

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

 

[Rohan]

yep, it is working now...

Thank you very much!
Rohan

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

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

besides creating a permanent hyperlink or bringing the data into the second
workbook? No.

--
Regards,
Tom Ogilvy


:

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