| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| An error msg in Excel 2007 regarding Linking but no linking in fil | Excel Discussion (Misc queries) | |||
| Linking | Excel Discussion (Misc queries) | |||
| Linking | Excel Discussion (Misc queries) | |||
| linking | Excel Discussion (Misc queries) | |||
| linking | Excel Discussion (Misc queries) | |||
Linear Mode
