Linking


P

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
 
Ad

Advertisements

L

Luke M

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

Pat

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

Luke M said:
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 said:
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
 
G

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
 
Ad

Advertisements

P

Pat

a bitmap

Gord Dibben said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top