can I link my Excel Cells to a table in a Word Document

[Dr. Darrell]

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

 

[Eduardo]

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]

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]

Hi,
you can do paste special and choose text

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.

 

[Dr. Darrell]

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]

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")