Add hyperlinked image to excel????

[dyerucf]

I have an image in my excel workbook that functions as a dynamic hyperlink, ie it references two cells to get data to send to the browser. This is a PAYNOW link for my merchant payment gateway. What I want to know is how to add this link to an image in my page?

Here is the link that works when I use =HYPERLINK

=HYPERLINK("https://payjunction.com/live/shop/snap_check_out?store=***********&description=Invoice:"&N3&"&price="&N57&",&need_to_tax=no&need_to_ship=no")

When I add an image to the page, ie a PAY NOW" Button and try to add a hyperlink to it I use the above code and it is screwing with the cell references, when I click the link I get this:

file://localhost/=HYPERLINK(%22https/:😛ayjunction.com:live:shop:snap_check_out%3Fstore=kru*****&description=Invoice/%22&N3&%22&price=%22&N57&%22,&need_to_tax=no&need_to_ship=no%22)


You can see that its messing up on the quotes, I have tried removing the =HYPERLINK function but that doesnt work I get this:

https://payjunction.com/live/shop/s...price="&N57&",&need_to_tax=no&need_to_ship=no


The problem appears to be in how excel or html handles the " but I dont know how to fix it.

Any help would be great.

 

[dyerucf]

Update

One thing I thought about doing is putting the correct hyperlink in a cell, hide that cell and see if I can just get the image to act as a hyperlink to another cell, ie N73 on the page and click thru that but it didnt work

 

[TheSteveW]

It's the 's'

Excel doesn't like "https" (vs http). It turns it into a local file link. Excel help is useless. I think it has something to do with the "update links" option in web options but I can't get it to work consistently. I turned that option off on a spreadsheet I've been using and got it to leave the https links alone for a while but today it's back to it's old tricks.

If I find a reliable fix I'll let you know.