Add hyperlinked image to excel????

Discussion in 'macOS' started by dyerucf, May 15, 2008.

  1. dyerucf macrumors regular

    dyerucf

    Joined:
    Jan 15, 2008
    Location:
    Alpharetta, GA
    #1
    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/::payjunction.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.
     
  2. dyerucf thread starter macrumors regular

    dyerucf

    Joined:
    Jan 15, 2008
    Location:
    Alpharetta, GA
    #2
    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
     
  3. TheSteveW macrumors newbie

    Joined:
    Jun 13, 2008
    #3
    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.
     

Share This Page