Prev: Cannot open spreadsheet
Next: using THREED function with VLOOKUP to sum across multiple workshee
From: Gord Dibben on 31 Mar 2010 12:05
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




On Wed, 31 Mar 2010 07:26:02 -0700, gloria.lewis(a)dreamvirtualassistant.com
<glorialewisdreamvirtualassistantcom(a)discussions.microsoft.com> wrote:

>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" wrote:
>
>> 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
>>
>> On Tue, 30 Mar 2010 14:24:09 -0700, gloria.lewis(a)dreamvirtualassistant.com
>> <glorialewisdreamvirtualassistantcom(a)discussions.microsoft.com> wrote:
>>
>> >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.
>>
>> .
>>

First  |  Prev  | 
Pages: 1 2
Prev: Cannot open spreadsheet
Next: using THREED function with VLOOKUP to sum across multiple workshee