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
|