H
Hung
Hi,
I got a problem with Hyperlink function, and see if anyone knows how to fix
it:
My spreadsheet has 2 columns:
- Column A (from A2..A10 is the Parameter)
- Column B (from B2..B10) is expected to be a hyperlink to a predefined
webpage, that will accept the corresponding parameter from column A
Let's say:
- A2 = 12345
- A3 = 54321
....
- B2 = HYPERLINK("http://www.mysite.com/myscrip.cgi&Param=" & A2, "Link")
- Copy the formula downto B10
Everything is fine until here:
- B2 will have the text "Link" which will bring me to my expected url:
http://www.mysite.com/myscrip.cgi&Param=12345
- And the same to B3 till B10
The problem happened when I modified column A to new values:
- Let's say, change A2 to 11111
- B2 will still say at the old url
(http://www.mysite.com/myscrip.cgi&Param=12345)
instead of changing the param to the new value
If I want the url to be updated, I had to remove the formula in B2 and enter
again.
Is there something that I can do to ask HYPERLINK to refresh its link?
Thanks
I got a problem with Hyperlink function, and see if anyone knows how to fix
it:
My spreadsheet has 2 columns:
- Column A (from A2..A10 is the Parameter)
- Column B (from B2..B10) is expected to be a hyperlink to a predefined
webpage, that will accept the corresponding parameter from column A
Let's say:
- A2 = 12345
- A3 = 54321
....
- B2 = HYPERLINK("http://www.mysite.com/myscrip.cgi&Param=" & A2, "Link")
- Copy the formula downto B10
Everything is fine until here:
- B2 will have the text "Link" which will bring me to my expected url:
http://www.mysite.com/myscrip.cgi&Param=12345
- And the same to B3 till B10
The problem happened when I modified column A to new values:
- Let's say, change A2 to 11111
- B2 will still say at the old url
(http://www.mysite.com/myscrip.cgi&Param=12345)
instead of changing the param to the new value
If I want the url to be updated, I had to remove the formula in B2 and enter
again.
Is there something that I can do to ask HYPERLINK to refresh its link?
Thanks