Forgive my ignorance towards excel and potentially inaccurate terminology. I have a sheet that contains a list of images contained in a subfolder, I have created a formula that returns the proper file path for each image contained in the folder. I want to dynamically hyperlink to each individual file so when I click the file name, it opens the image. The first instance of this formula works perfectly. However, the rest of the links return an error: "Alert Cannot open the specified file." What is even more strange is once I establish the link manually, on the second or third row, the link works as it should almost as if it cached the proper location once pointed at it. I would manually do it, but this is a fairly large image database and I would love to be able to automate this in the future. Thanks for any thoughts.