• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hyperlink not updating

Douglas Powell

Douglas Powell

New Member
Hi all,

I am using Excel 2016 and have a problem with hyperlink().

On a [Dashboard] tab I use a combination of Index() & Match() to fill data into two cells "B11" & "B12" and display results from a [Part Master] tab in the same spreadsheet. I "B13" I then pre-format a search for these parts on Google using hyperlink. So the result is a web link with the search terms baked into the search.

=HYPERLINK("https://www.google.com/search?q="&B11&"+"&B12,B11&": "&B12)

So now when I search match a new part number, the new data loads into B11 & B12 and the hyperlink does not update with the new results. In fact, if I hover the mouse over the formula, the popup tool shows the previously calculated results followed by the words "Click once to follow. Click and hold to select this cell." Try as I might I can't seem to get the web link to dynamically update the actual link.

Has anyone else seen and possibly solved this?

Thanks a bunch, Doug

UPDATE: I just checked again and a second instance of a similar formula is dynamically updating and the original is not! The second is actually a copy, paste and edit of the text from the original. this makes even less sense to me than ever. ~Doug
 
Hi Douglas,

Try this, this is working fine for me.

=HYPERLINK("https://www.google.com/search?q="&SUBSTITUTE(A1," ","+"),"Search Google for "&A1)



Douglas Powell said:
Hi all,

I am using Excel 2016 and have a problem with hyperlink().

On a [Dashboard] tab I use a combination of Index() & Match() to fill data into two cells "B11" & "B12" and display results from a [Part Master] tab in the same spreadsheet. I "B13" I then pre-format a search for these parts on Google using hyperlink. So the result is a web link with the search terms baked into the search.

=HYPERLINK("https://www.google.com/search?q="&B11&"+"&B12,B11&": "&B12)

So now when I search match a new part number, the new data loads into B11 & B12 and the hyperlink does not update with the new results. In fact, if I hover the mouse over the formula, the popup tool shows the previously calculated results followed by the words "Click once to follow. Click and hold to select this cell." Try as I might I can't seem to get the web link to dynamically update the actual link.

Has anyone else seen and possibly solved this?

Thanks a bunch, Doug

UPDATE: I just checked again and a second instance of a similar formula is dynamically updating and the original is not! The second is actually a copy, paste and edit of the text from the original. this makes even less sense to me than ever. ~Doug
Click to expand...
 
You must log in or register to reply here.
Back
Top