Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HYPERLINK() referring value from a cell does not change when cell
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 he - 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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HYPERLINK() referring value from a cell does not change when cell
Hung I tried what you've described and the hyperlink function responds
immediately. So it's probably not the function itself but maybe the setting of the spreadsheet. So I'd try changing your A2 cell again and then hit the "F9" (Function 9) key. If your hyperlink changes, then go into the Tools menu, then -Options then -Calculation tab and select "automatic". Michael On Jun 4, 7:04 pm, Hung wrote: 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 he - B2 will have the text "Link" which will bring me to my expectedurl: 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 oldurl (http://www.mysite.com/myscrip.cgi&Param=12345) instead of changing the param to the new value If I want theurlto 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum values referring to a cell with same value | Excel Discussion (Misc queries) | |||
referring to a cell containing a file name | Excel Discussion (Misc queries) | |||
Referring to a hyperlink | Excel Discussion (Misc queries) | |||
How to return a value Referring to the other cell. | Excel Worksheet Functions | |||
cell text referring to tab name | Excel Worksheet Functions |