how to link excel spreadsheets that are embedded in word
 

is is possible to link spreadsheets that are embedded in word, without
creating a separte excel file and using the paste special, link commands?

Are you trying to link two workbooks, one within a Word file, or are you
trying to embed a workbook in Word? I don't understand the question.
************
Anne Troy
www.OfficeArticles.com

"realmike" wrote in message
...
is is possible to link spreadsheets that are embedded in word, without
creating a separte excel file and using the paste special, link commands?

Mike,

If the sheets are in the same embedded workbook, it should be embedded in
the Word document only once. You can copy the embedded workbook, in Word,
(it doesn't matter which cells of which sheet you see -- it embeds the
entire workbook, not just a sheet), and Paste special - Excel object - Paste
link into another part of the Word document. YOu can only update the
original, but changes will be reflected in the linked one.
--
Earl Kiosterud
www.smokeylake.com

"realmike" wrote in message
...
is is possible to link spreadsheets that are embedded in word, without
creating a separte excel file and using the paste special, link commands?

Thx for the note - I have two excel sheets embedded in a word doc and I want
to link cells so that when I change one of the sheets the changes are made in
the second sheet.

"Anne Troy" wrote:

Are you trying to link two workbooks, one within a Word file, or are you
trying to embed a workbook in Word? I don't understand the question.
************
Anne Troy
www.OfficeArticles.com

"realmike" wrote in message
...
is is possible to link spreadsheets that are embedded in word, without
creating a separte excel file and using the paste special, link commands?

Thx for the answer - I'm trying it out right now,

Mike


"Earl Kiosterud" wrote:

Mike,

If the sheets are in the same embedded workbook, it should be embedded in
the Word document only once. You can copy the embedded workbook, in Word,
(it doesn't matter which cells of which sheet you see -- it embeds the
entire workbook, not just a sheet), and Paste special - Excel object - Paste
link into another part of the Word document. YOu can only update the
original, but changes will be reflected in the linked one.
--
Earl Kiosterud
www.smokeylake.com

"realmike" wrote in message
...
is is possible to link spreadsheets that are embedded in word, without
creating a separte excel file and using the paste special, link commands?

how to link excel spreadsheets that are embedded in word
 

I have a simular issue. I have 2 worksheets embedded in Word. Both are
built using the Excel embed option from the Word toolbar. Theses Workbooks
do not exitst anyware else. I need to reference a cell from one in a formula
in the other.

"realmike" wrote:

Thx for the answer - I'm trying it out right now,

Mike


"Earl Kiosterud" wrote:

Mike,

If the sheets are in the same embedded workbook, it should be embedded in
the Word document only once. You can copy the embedded workbook, in Word,
(it doesn't matter which cells of which sheet you see -- it embeds the
entire workbook, not just a sheet), and Paste special - Excel object - Paste
link into another part of the Word document. YOu can only update the
original, but changes will be reflected in the linked one.
--
Earl Kiosterud
www.smokeylake.com

"realmike" wrote in message
...
is is possible to link spreadsheets that are embedded in word, without
creating a separte excel file and using the paste special, link commands?