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

  • Thread starter Thread starter Dr. Darrell
  • Start date Start date
D

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
 
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.
 
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.
 
Hi,
you can do paste special and choose text

Dr. Darrell said:
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.
Click to expand...
 
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?
 
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")
 
Back
Top