Hyperlinks to open photos

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 o...