[CyberTaz]

The easiest way I know of:

Assign a Range Name to the target cell, then recreate the link or edit the
link in your Word doc to replace the cell reference with the range name. If
you call the range "bubba" for example, your link field in Word would look
something like:

{ LINK Excel.Sheet.8 "WkbkName" "SheetName!bubba" \a\p }

Note: In order for the field code to display (Alt+F9) it should be set to
InLine With Text rather than as a floating object.


Another way: In any cell (we'll call it "proxy") of the XL workbook create a
formula link that points to the desired target cell wherever it happens to
be at the time. The proxy will stay updated when the actual target cell
shifts to a different grid position. Then recreate your link from Word to
the proxy cell.

IOW - Say your target cell is L25... In some other cell of the worksheet
(proxy) type in =L25 which will establish a formula link to that cell.
[Note: If proxy is not on the same sheet as the target cell the formula link
must include the sheet name as well as the cell reference. Easiest way to
get it right is to just type the = then click the target sheet tab, then
click the target cell & press Enter.] Then link from Word to proxy rather
than to L25.

Other options may be available as well so you may want to ask in the
microsoft.public.excel newsgroup to see what they have to offer.
--
HTH |:)
Bob Jones
[MVP] Office:Mac

"SueK" wrote in message
...
I have created a link between Excel and Word that anytime I change or
update
a cell in Excel, it updates a specific spot in Word. I did this by
copying
the cell in Excel and then paste special, paste link as unformatted text
in
Word. It worked great until we deleted some rows in Excel and discovered
that the links in Word stays with the row it was linked to so it now
updates
with the wrong information. Is there a way to preserve this link so rows
can
be deleted or sorted in Excel and the correct information will be updated
in
my Word document?

Thanks for any help!