Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
How do I link picture files (e.g. PNG-files) in Excel so that they can be
automatically updated? Did Microsoft forget to enable OLE-functions in Excel 2003 for graphics? I tried several ways to paste the picture as a link, no success! 1) It is not possible to copy the pictures from Office Picture Manager into Office Clipboard. 2) Copy into system clipboard works, but under paste special in Excel "paste link" is inactive. 3) It's also not possible to link a picture file through: Insert/ Picture/ From file... which is possible in Word 2003. 4) Insert/ Object/ Create from file... doesn't show the picture but an icon, although "Link to file" is checked. It links the file as "package" instead of e.g. "paint.picture" Thanks in advance! |
#2
![]() |
|||
|
|||
![]()
I don't know exactly what you want to do, but try hyperlinking to your
picture files. Right-click on a cell, click 'Hyperlink.' When the 'Insert Hyperlink' Menu comes up, find your picture file and insert. "ODI" wrote: How do I link picture files (e.g. PNG-files) in Excel so that they can be automatically updated? Did Microsoft forget to enable OLE-functions in Excel 2003 for graphics? I tried several ways to paste the picture as a link, no success! 1) It is not possible to copy the pictures from Office Picture Manager into Office Clipboard. 2) Copy into system clipboard works, but under paste special in Excel "paste link" is inactive. 3) It's also not possible to link a picture file through: Insert/ Picture/ From file... which is possible in Word 2003. 4) Insert/ Object/ Create from file... doesn't show the picture but an icon, although "Link to file" is checked. It links the file as "package" instead of e.g. "paint.picture" Thanks in advance! |
#3
![]() |
|||
|
|||
![]()
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 output of a statistic 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? 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 again! "FinRazel" wrote: I don't know exactly what you want to do, but try hyperlinking to your picture files. Right-click on a cell, click 'Hyperlink.' When the 'Insert Hyperlink' Menu comes up, find your picture file and insert. "ODI" wrote: How do I link picture files (e.g. PNG-files) in Excel so that they can be automatically updated? Did Microsoft forget to enable OLE-functions in Excel 2003 for graphics? I tried several ways to paste the picture as a link, no success! 1) It is not possible to copy the pictures from Office Picture Manager into Office Clipboard. 2) Copy into system clipboard works, but under paste special in Excel "paste link" is inactive. 3) It's also not possible to link a picture file through: Insert/ Picture/ From file... which is possible in Word 2003. 4) Insert/ Object/ Create from file... doesn't show the picture but an icon, although "Link to file" is checked. It links the file as "package" instead of e.g. "paint.picture" Thanks in advance! |
#4
![]() |
|||
|
|||
![]()
This web site has solved the problems of several people with like issues in
this newsgroup. Check it out. http://www.mcgimpsey.com/excel/lookuppics.html "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 output of a statistic 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? 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 again! "FinRazel" wrote: I don't know exactly what you want to do, but try hyperlinking to your picture files. Right-click on a cell, click 'Hyperlink.' When the 'Insert Hyperlink' Menu comes up, find your picture file and insert. "ODI" wrote: How do I link picture files (e.g. PNG-files) in Excel so that they can be automatically updated? Did Microsoft forget to enable OLE-functions in Excel 2003 for graphics? I tried several ways to paste the picture as a link, no success! 1) It is not possible to copy the pictures from Office Picture Manager into Office Clipboard. 2) Copy into system clipboard works, but under paste special in Excel "paste link" is inactive. 3) It's also not possible to link a picture file through: Insert/ Picture/ From file... which is possible in Word 2003. 4) Insert/ Object/ Create from file... doesn't show the picture but an icon, although "Link to file" is checked. It links the file as "package" instead of e.g. "paint.picture" Thanks in advance! |
#5
![]() |
|||
|
|||
![]()
Thanks for the link, but I had already checked it out, before I posted my
question. I still don't have an answer for it. It seems nobody needs to link graphics and update them in Excel. I searched with Google different sites, no success! Thanks again! I won't give up till I find a solution. "FinRazel" wrote: This web site has solved the problems of several people with like issues in this newsgroup. Check it out. http://www.mcgimpsey.com/excel/lookuppics.html "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 output of a statistic 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? 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 again! "FinRazel" wrote: I don't know exactly what you want to do, but try hyperlinking to your picture files. Right-click on a cell, click 'Hyperlink.' When the 'Insert Hyperlink' Menu comes up, find your picture file and insert. "ODI" wrote: How do I link picture files (e.g. PNG-files) in Excel so that they can be automatically updated? Did Microsoft forget to enable OLE-functions in Excel 2003 for graphics? I tried several ways to paste the picture as a link, no success! 1) It is not possible to copy the pictures from Office Picture Manager into Office Clipboard. 2) Copy into system clipboard works, but under paste special in Excel "paste link" is inactive. 3) It's also not possible to link a picture file through: Insert/ Picture/ From file... which is possible in Word 2003. 4) Insert/ Object/ Create from file... doesn't show the picture but an icon, although "Link to file" is checked. It links the file as "package" instead of e.g. "paint.picture" Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Office 97 hyperlinks do not work in excel 2003 | Excel Discussion (Misc queries) | |||
How do I open a Quattro Pro 7.0 file in Excel 2003 | Excel Discussion (Misc queries) | |||
Why doesn't CTRL+SHIFT+[ARROW] work 2 highlight in Excel 2003?! | Excel Discussion (Misc queries) | |||
quattro pro converter Excel 2003 | New Users to Excel |