Hyperlinks to open photos

Copper Contributor

Hi. I have over 1000 photos in a folder that related to over 1000 lines of data in a spreadsheet. I tried to put a hyperlink to each line of data, mapping the folder path and photo name but it will only open the folder when I create the hyperlink. I do not want to individually go in, find the photo and then link it. For example, I put D:/File_Location/PhotoName.jpg but it still only opens the folder even tho it is pointing to the photo. Is anyone able to offer advice on how to get it to link to the photo not just the folder please?

1 Reply