Forum Discussion

DavidAz81's avatar
DavidAz81
Copper Contributor
Nov 10, 2020
Solved

Show image from url while hovering mouse

Hello.   I've been trying to do this for days and it's driving me crazy.   I have an Excel file with thousands of URL of images on column A such as: www.mywebsite.com/images/001.png www.mywebsi...
  • EduardoForero's avatar
    EduardoForero
    Jul 20, 2021

    DavidAz81  I believe I had the same issue using the code found at https://stackoverflow.com/questions/43923102/hover-preview-over-excel-image-link .  I had the same problem until a saw a comment when they explained the updated reference.    The solution is simple.  first use the hyperlink function in your language, but more than this, you need to correct the cell code. in the original post it was   "=HYPERLINK(OnMouseOver("http://i.imgur.com/rQ5G8sZ.jpg"),"http://i.imgur.com/rQ5G8sZ.jpg")" but it should be changed to =HYPERLINK(OnMouseOver("http://i.imgur.com/rQ5G8sZ.jpg";A1); "http://i.imgur.com/rQ5G8sZ.jpg"

     

    Any way, i did use it like this.   On A column i have the list of hyperlinks (in text such as https://sitename.com/filename.jpg) (A2 is the first image),  on B column I use this formula (on B2)  I have =HYPERLINK(OnMouseOver(A2;B2);A2)   on C column the =HYPERLINK(Reset()) .

     

    in this sample I used the same image link on all cells (lazy me) but it works.  .    anyway, it is not the best solution yet. I am working on other easier way.   this is a screenshot of the sample.

     

    Hope it helps someone.. .  the real advantage in this one is that you do not save all pictures in the excel file,  as you say, if your list is large it would not be practical, but I think there must be a better way.   i have included the sample file, but in case you don't want to download a unknown file, just follow the instructions.

     

Resources