Linking

[Pat]

I need to link one cell (contains words) in one workbook to a cell in another
workbook. In the first workbook I have an picture (pasted)into the same
cell as the words. How can I link the words and the embedded picture to the
one cell in the second workbook

 

[Luke M]

One way would be to use a HYPERLINK in the cell.
=HYPERLINK('[MyWorkbook.xls]Sheet1'!$A$3,"Words to display")

 

[Pat]

I still cannot get the picture to link (it is inserted as a picture in the
cell)

One way would be to use a HYPERLINK in the cell.
=HYPERLINK('[MyWorkbook.xls]Sheet1'!$A$3,"Words to display")
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

I need to link one cell (contains words) in one workbook to a cell in another
workbook. In the first workbook I have an picture (pasted)into the same
cell as the words. How can I link the words and the embedded picture to the
one cell in the second workbook

 

[Gord Dibben]

How did you embed the object into the cell?

You cannot paste a picture into a cell.

In order to "embed" it you must insert as a bitmap object or a package.


Gord Dibben MS Excel MVP

 

[Pat]

a bitmap

How did you embed the object into the cell?

You cannot paste a picture into a cell.

In order to "embed" it you must insert as a bitmap object or a package.


Gord Dibben MS Excel MVP