Well - this turned out to be embarrassingly simple.

I was on the right track earlier by doing an insert picture and selecting
insert and link. That was good. What I did not do is close Excel
completely - not just the worksheet - the whole darn Excel app. That is
what causes it to refresh the link, not just reopening the book.

Thanks all for your help in this.

--
Glenn

"Glenn Mulno" wrote in message
...
Hi,

First - I apologize - I posted this earlier on public.excel - so this is a
cross post. I apologize if you subscribe to that list and this is a
repeat. Just trying to get a wider audience.

I am trying to have Excel show/display an image from a file and be able to
update/refresh that image if it changed but am not having any luck. The
image file will get updated weekly - so I am not looking to embed an image
one time. I want it to link to the source file and when I update the image
file, it will reflect the new image in Excel the next time Excel opens.

Inserting an image file embeds the image but there is no link to the
source file for updates.

I tried using the image control - but that did not appear to work right.
It did display the image, and I can resize the image to proper form - but
the image does not update the next time I open Excel after replacing the
image. There is a property of the image control called "AutoLoad" - but
after I set it to True - when I close and then reopen Excel - the image
does not refresh and that property is somehow reset to False.

At the moment - I am getting images sent to me in .png format - if the
solution could handle that it would be great. The steps I tried above I
tried with a converted jpg image and that did not work. The png image
file seems even less friendly.

I am using MS Office 2007 and the file is a .xlsm (macro enabled) file.

Thanks for any help you can provide.

--
Glenn