type simultaneously

[Guest]

Is it possible to create fields in a Word document where you can include text
from an excel cell and be able to update it? For the word documents, i click
Insert-File-Range (then type the bookmark name) and then click insert as
link. then in the document, i right click the text and it says "update
field". I need to do this with an excel document. I am able to insert the
cell into the word document, but when i right click, im not able to update
the field. How can i do this?

 

[CyberTaz]

It sounds like you're just copying & *pasting* into the Word doc. Instead,
use Edit> Paste Special & click the Link option. You can use most of the
object types listed in the As: list.

 

[Guest]

That solution does not work. What I am trying to do is include the text in a
cell in an excel file in a word document. i have done this by clicking
Insert--File--(file path)--Range--(cell coordinates)--Insert as link. This
properly inserts the cell into the word file. Im wondering if it is possible
to be able to right click the field and update it automatically, like i can
when i insert bookmarks from other word files.

 

[CyberTaz]

Well, yeah, it sure does work

What you are trying to do creates an INCLUDETEXT field which doesn't work
well with anything other than another Word doc and often results in an
"undefined bookmark" error.

I think what's making you think my suggestion doesn't work is that the
Update Field command doesn't appear in the contextual menu when you just
right-click the linked content. If you use either a) Edit> Links, b) select
the linked content before rt-clicking it or c) click in the link & press F9
I think you'll find you get exactly what you want... and if the Excel file
is open at the same time as the doc you don't have to update the field at
all - it will update automatically unless you set it to Manual.

 

[Guest]

Thanks.
If i click: Insert | Object....do i have to insert the whole document, or
can i pinpoint a bookmark//cell?