Re: field = to

Tech-Archive recommends: Fix windows errors by optimizing your registry

Jezebel
Here is my link, which is not updating when I make changes:
{LINK Excel *** 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 *** 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 ***.
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 *** changes.




"Joanne" <jobobbuss@xxxxxxxxxxxxx> wrote in message
news:ei4FXZEsGHA.3412@xxxxxxxxxxxxxxxxxxxxxxx
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



.

Quantcast