Linking
 

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

Linking
 

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!*


"Pat" wrote:

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

Linking
 

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

"Luke M" wrote:

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!*


"Pat" wrote:

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

Linking
 

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

On Mon, 15 Dec 2008 10:46:01 -0800, Pat
wrote:

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

Linking
 

a bitmap

"Gord Dibben" wrote:

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

On Mon, 15 Dec 2008 10:46:01 -0800, Pat
wrote:

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