First: don't know why your link isn't updating. The _121... bit is a
Word-generated bookmark. When I tried it, I got a reference like that with
the document not saved, replaced by OLE_LINK1 (which is also an automatic
bookmark) when the document was saved.
Did you try updating fields?

As for making the cell reference variable: in principle you should be able
to name the cell, then use the cell name in place of the "R8C2" -- this
certainly works from a linked workbook. Never tried it with an embedded
sheet.



"Joanne" wrote in message
...
Jezebel
Here is my link, which is not updating when I make changes:
{LINK Excel Sheet 8 "C:\\Documents and Settings\Joanne\\My
Documents\\non-discount.doc" "_1215402019!Sheet1!R8C2" \a \t

Can you see where I might have made a mistake that is causing it to
not update?
And while I have your busy attention, is there a way to pass the cell
addr from the excel sheet as a variable to the link so that if the
list happens to be longer, it will still update?

Thanks for your time
Joanne

Jezebel wrote:

Select and copy the total within the embedded sheet.
Select the location in the document where you want the total to appear.
Click Edit PasteSpecial. Check 'Paste Link' and select 'Unformatted
text'
from the 'As' list.

You'll end up with a field that looks something like --

{ LINK Word.Document "C:\\MyFolder\\MyFile.doc" "OLE_LINK1" \a \t }

This will update automatically when the embedded sheet changes.




"Joanne" wrote in message
...
I have an excel table in my document.
It lists invoice numbers and their amounts, then gives me a total.
What I would like to do is make a field in my doc = to the total
generated by the excel table.
Looking at insert/fields I don't know whether to use doc automation,
links and references, equations and formulas or if none of the above
are correct.
Please give me some help on this problem
Thanks a bunch ahead of time
Joanne