Linking to Graphics

S

scw1217

Is there a way in Excel 2003 to link column text to a .jpg photograph o
my computer? I have to track inventory and would like to be able to se
the object in question. If not, what options are available. I am ne
to 2003 and have only used 97. Thanks
 
D

Dave Peterson

Maybe you could just hyperlink to that file.

=hyperlink("File:////c:/pictures/pict1.jpg")
 
T

Terah

Would this work if the pictures are all in the same file but on another
worksheet? They wouldn't have different names. I was trying access them
using cell references when they were selected with a drop down box.

Dave Peterson said:
Maybe you could just hyperlink to that file.

=hyperlink("File:////c:/pictures/pict1.jpg")
Click to expand...
 
D

Dave Peterson

How about if you just hyperlinked a cell under the picture on that other
worksheet:

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)
Would this work if the pictures are all in the same file but on another
worksheet? They wouldn't have different names. I was trying access them
using cell references when they were selected with a drop down box.
Click to expand...
 
T

Terah

Would that take me to the page with the graphics? I need for the graphic to
come back to the 'front' page.

Dave Peterson said:
How about if you just hyperlinked a cell under the picture on that other
worksheet:

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)
Click to expand...
 
Top