How to embed JPEG in workbook with a copy saved in excel - or a hyperlink to it

Hey guys, first off thanks for the help. Tried searching but didn't find anything related.

For work I have to take pictures of several different features and add pricing information and condition etc. Basically I want to embed a jpeg file in the workbook with a saved copy in the actual file. So the columns would look something like A:Item B: Condition C: Value D: New Item E: Hyperlink to Image
I know you can hyperlink from your own directory and load a copy from there, but this will be sent to the client and obviously they will not have access to my desktop. Ideally this would open in a separate image viewer album or something related.

While this would be my preferred solution because it would be a lot cleaner, is there a way to put each picture in a separate sheet and hyperlink to the sheet from the main sheet?

This is what I have tried so far

I tried making a zipped folder containing both the images and the excel file, and sent that to a different computer but when opened there was nothing in the excel sheet. I had added just generic words and numbers as well but even those didn't appear.

I then tried linking to the images from the zipped folder itself instead of linking from my desktop and then sending the folder, but it didn't give me the option to even select images in the zipped folder.

I then tried making separate zip folders for the spreadsheet and the images and then linking to the images from the one zipped folder to the excel sheet, but again it wouldn't allow me to link any images.

I am assuming this is because the zipped file compresses the images and Excel cannot unzip them and insert them, but I can't send my client like 40 different attachments of photos. This also wouldn't work because the hyperlink is addressed within my directory so it would need the new file pathway to properly open.


Thanks so much! Just started working and want to make a good first impression.

Will this do the job for you?

I did one hyperlink within the workbook. For this to work you would have to insert the picture in a separate sheet and just link to it.

I also did a hyperlink to a picture in my public dropbox folder. See workbook for further.