HYPERLINK() referring value from a cell does not change when cell

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
 
M

mcheng

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top