Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I want to embed a picture from the web in an excel spreadsheet.

I want to embed the picture by url, in the same manner that pictures are embedded in an html page. I don't want to download the picture and insert it as a regular picture.

And I want the picture to be displayed (if I am online, of course), not just the url.

Can this be done? If so how?

Preferably in excel, but OO calc would be ok to

share|improve this question
1  
Just in case this ever gets you strange errors, then it's good to know that Office might use a browser ("User Agent") known as "Microsoft Office Existence Discovery" before even trying to fetch the image. That User Agent might be seen as a search robot, and hence on some web sites might have different access rights than the IE component that is used to actually fetch the image... A little more info at superuser.com/questions/41935/… –  Arjan Oct 8 '09 at 12:50

2 Answers 2

In Excel, go to Insert > Picture > From file... and type the URL of the picture you want to insert. I don't know if the picture updates itself since I've never tried it.

share|improve this answer
    
I believe that will just read the picture from the web. –  harrymc Oct 8 '09 at 12:34
    
Yes, It does. It works –  ukanth Oct 8 '09 at 12:39

I think the solution is to write a VBA macro that will retrieve the image and embed it into the worksheet.

I think that's the only way for this image to be automatically refreshed.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.