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

[bfritz7259]

[FONT=&quot]Hey guys, first off thanks for the help. Tried searching butdidn't find anything related.<o></o>[/FONT]
[FONT=&quot]For work I have to take pictures of several different featuresand add pricing information and condition etc. Basically I want to embed a jpegfile in the workbook with a saved copy in the actual file. So the columns wouldlook something like A:Item B: Condition C: Value D: New Item E: Hyperlink toImage<o></o>[/FONT]
[FONT=&quot]I know you can hyperlink from your own directory and load a copyfrom there, but this will be sent to the client and obviously they will nothave access to my desktop. Ideally this would open in a separate image vieweralbum or something related.<o></o>[/FONT]
[FONT=&quot]While this would be my preferred solution because it would be alot cleaner, is there a way to put each picture in a separate sheet andhyperlink to the sheet from the main sheet?<o></o>[/FONT]
[FONT=&quot]This is what I have tried so far<o></o>[/FONT]
[FONT=&quot]I tried making a zipped foldercontaining both the images and the excel file, and sent that to a differentcomputer but when opened there was nothing in the excel sheet. I had added justgeneric words and numbers as well but even those didn't appear.<o></o>[/FONT]
[FONT=&quot]I then tried linking to the images from the zipped folder itselfinstead of linking from my desktop and then sending the folder, but it didn'tgive me the option to even select images in the zipped folder.<o></o>[/FONT]
[FONT=&quot]I then tried making separate zip folders for the spreadsheet andthe images and then linking to the images from the one zipped folder to theexcel sheet, but again it wouldn't allow me to link any images.<o></o>[/FONT]
[FONT=&quot]I am assuming this is because the zipped file compresses the imagesand Excel cannot unzip them and insert them, but I can't send my client like 40different attachments of photos. This also wouldn't work because the hyperlinkis addressed within my directory so it would need the new file pathway toproperly open.<o></o>[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Thanks so much! Just started working and want to make a goodfirst impression.<o></o>[/FONT]

 

[Microsoft]

As far as I'm aware you cannot embed a full copy of a file/document into an Excel workbook for your client to open.

The only option I can think of is to have a separate tab for each picture, then hyperlink to there. It's not the best solution in the world as your document will end up having 40+ tabs, but you won't have to send your client a load of photos by email.

Insert the picture into the an Excel sheet by using Insert --> Pictures.

Good luck finding a solution.

 

[bfritz7259]

Alright so it actually is possible, just for future information. Create a new top level folder that contains both the excel file and the hyperlinked JPEG images. Zip/Compress that folder and send it to the desired recipient. The critical part is that the recipient has to extract the zip file before the hyperlinks become active, otherwise it will just appear as "cannot open specified file." On my copy of Windows 10 the extract button is in the top ribbon under a red header that says "compressed folder tools"

 

[bfritz7259]

all credit goes to u/badaccountant7