Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
want to link excel doc. to pdf. | Excel Discussion (Misc queries) | |||
Embedded Excel Spreadsheet in MS Word Corrupted | Excel Worksheet Functions | |||
Networking excel spreadsheets error | Excel Discussion (Misc queries) | |||
most effective way to link ms word tables to excel | Excel Discussion (Misc queries) | |||
Open a file in excel from a link in eplorer | Excel Discussion (Misc queries) |