| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can I link my Excel Cells to a table in a Word Document
I would like to link some cells in an Excel File to some Cells in a Word
Document's Table. Is there an effectict way to do this? The Word Document is a living Document which has values changing periodically, and I would like my cells in the Excel File to change along with them. Darrell |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
can I link my Excel Cells to a table in a Word Document
highlight the range I need in Excel, copy, go to
Word, select Paste-Special-Microsoft Excel Object, and then check the circle that says Paste-Link. "Dr. Darrell" wrote: I would like to link some cells in an Excel File to some Cells in a Word Document's Table. Is there an effectict way to do this? The Word Document is a living Document which has values changing periodically, and I would like my cells in the Excel File to change along with them. Darrell |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
can I link my Excel Cells to a table in a Word Document
I need to go in the other direction. I need the value whic is in the word
document to appear in my excel file. When I try to do your steps, the row of the table gets inserted as an object. "Eduardo" wrote: highlight the range I need in Excel, copy, go to Word, select Paste-Special-Microsoft Excel Object, and then check the circle that says Paste-Link. "Dr. Darrell" wrote: I would like to link some cells in an Excel File to some Cells in a Word Document's Table. Is there an effectict way to do this? The Word Document is a living Document which has values changing periodically, and I would like my cells in the Excel File to change along with them. Darrell |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
can I link my Excel Cells to a table in a Word Document
Hi,
you can do paste special and choose text "Dr. Darrell" wrote: I need to go in the other direction. I need the value whic is in the word document to appear in my excel file. When I try to do your steps, the row of the table gets inserted as an object. "Eduardo" wrote: highlight the range I need in Excel, copy, go to Word, select Paste-Special-Microsoft Excel Object, and then check the circle that says Paste-Link. "Dr. Darrell" wrote: I would like to link some cells in an Excel File to some Cells in a Word Document's Table. Is there an effectict way to do this? The Word Document is a living Document which has values changing periodically, and I would like my cells in the Excel File to change along with them. Darrell |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
can I link my Excel Cells to a table in a Word Document
If I choose Text, then the value in my cell won't update when the value in
the Word Doc is changed. Am I correct with this statement? "Eduardo" wrote: Hi, you can do paste special and choose text "Dr. Darrell" wrote: I need to go in the other direction. I need the value whic is in the word document to appear in my excel file. When I try to do your steps, the row of the table gets inserted as an object. "Eduardo" wrote: highlight the range I need in Excel, copy, go to Word, select Paste-Special-Microsoft Excel Object, and then check the circle that says Paste-Link. "Dr. Darrell" wrote: I would like to link some cells in an Excel File to some Cells in a Word Document's Table. Is there an effectict way to do this? The Word Document is a living Document which has values changing periodically, and I would like my cells in the Excel File to change along with them. Darrell |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
can I link my Excel Cells to a table in a Word Document
Hi,
try Dave Peterson solution If I want a link in Excel that points at a specific location in an MSWord document, I'd add a bookmark to that document and use one of these: (Insert|hyperlink style) C:\MY DOCUMENTS\WORD\MyDoc.DOC#bkmk01 Or =hyperlink() style: =hyperlink("C:\MY DOCUMENTS\WORD\MyDoc.DOC#bkmk01") "Dr. Darrell" wrote: If I choose Text, then the value in my cell won't update when the value in the Word Doc is changed. Am I correct with this statement? "Eduardo" wrote: Hi, you can do paste special and choose text "Dr. Darrell" wrote: I need to go in the other direction. I need the value whic is in the word document to appear in my excel file. When I try to do your steps, the row of the table gets inserted as an object. "Eduardo" wrote: highlight the range I need in Excel, copy, go to Word, select Paste-Special-Microsoft Excel Object, and then check the circle that says Paste-Link. "Dr. Darrell" wrote: I would like to link some cells in an Excel File to some Cells in a Word Document's Table. Is there an effectict way to do this? The Word Document is a living Document which has values changing periodically, and I would like my cells in the Excel File to change along with them. Darrell |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to link a word document to a excel spreadsheet...how? | Excel Discussion (Misc queries) | |||
| Link Excel S/Sheet cells to Table in Word document | Excel Discussion (Misc queries) | |||
| Link Excel Spreadsheet to Word Document | Excel Discussion (Misc queries) | |||
| PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
| Is it possible to link an Excel spreadsheet to a Word document an. | Excel Discussion (Misc queries) | |||
Hybrid Mode
