Hyperlinking images

[gloria.lewis]

I have a worksheet with several columns. One of the columns is entitled
image which I've hyperlinked to image files.

I thought that if I were to email this worksheet to someone else that my
images would go along with it. Not happening.

How do I set it up, so that the images are embedded on each row as a file
name and if I email it to someone, all of the images are transferred also.

I know it's a simple solution, but I'm not finding it. Thanks.

 

[Gord Dibben]

You must either send all the image files along with the workbook or insert
the images into the workbook.

Sending the image files would also entail re-directing the hyperlinks to
where the recipient would store those images.


Gord Dibben MS Excel MVP

 

[מיכ×ל (מיקי) ×בידן]

You may consider to upload all the image files to a File Hosting Site [can,
easily, be found by "Googling"] and refer all the links to each of the images
on that site.
[Some sites delete the hosted files a after some time and other don't.
Micky

 

[gloria.lewis]

If I insert the images into the workbook (i.e. on a seperate sheet for each
group of images), how do I direct the hyperlink to that particular image.
Each sheet would have multiple images for each group of images (i.e. end
units, wire racks, etc.).

 

[gloria.lewis]

How do I link it so when the hyperlink is clicked on the image comes up in an
image viewer (i.e. Windows Picture and Fax Viewer or Internet Explorer).

 

[Gord Dibben]

If the images are simply inserted in the workbook, hyperlinking to them will
not open them in an external application.

You have to embed them as packaged objects in the workbook.

Insert>Object>Create from file

Checkmark "Display as Icon"

Browse to the image file and select.

You must do this for each image.

When you double-click on the Icon the image will open with the default
viewer.

NOTE: with many embedded objects you workbook can get quite large.

Re-size images before embedding.

More notes; to prevent the "harmful" warning you must deal with that.

In 2003 see this KB article.

http://support.microsoft.com/?kbid=829072

For 2007 go to Trust Center Settings and "enable all data connections"


Gord