View Single Post
  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default Insert & link a graphic file in Excel 2003 -- updatable pictu

Were you thinking of:

Insert|Object|create from file|check link to file?

ODI wrote:

It should have been working, because we had those links in excel sheets,
which are now not working!

VBA-Method Shapes.AddPicture(FileName, LinkToFile, SaveWithDocument, Left,
Top, Width, Height) didn't work either: it inserts the picture but without
linking. There's a problem with linking graphics - my opinion to that is:
Microsoft did forget to implement OLE functionality for graphics in Excel
2003...

I hope there will be a bug fix soon! And we have to install Office XP back
in order to work with our linked graphics!!!

Thanks for trying to help.

"Dave Peterson" wrote:

If I were a betting person, I'd say you were misremembering about xl2002. I
don't think it did what you describe.

In fact, I think if were approaching this problem, I'd use a macro to delete the
pictures and add them back--maybe even keep a helper worksheet that kept the
names of the picture files, the names I want to call each of the pictures, and
the position that they should be in when I add them.



ODI wrote:

I want to insert a graphic or a picture, it should be visible in Excel, but
linked with the file, so that when the file content changes, it is changed in
Excel too!

I have charts in png-format as automated outputs of a statistics application.
The file names are constant, but every month the content of the file is
different. Because the application produces new charts and saves them under
the same filename.
The links were updated automatically in Excel sheets with the XP version of
Office. It was also possible to insert the pictures as linked object in the
earlier version. What happened with this feature? In Word 2003 it's possible
to link a picture file through: Insert/ Picture/From file... The
"Insert"-Button has the option to link the content, which is not the case in
Excel!

My question again: How do I paste linked (not embedded!) pictures in Excel
2003, so that the picture can be updated and visible in Excel? I don't want a
hyperlink or an icon to open the files.

Thanks!


--

Dave Peterson


--

Dave Peterson