Re: Excel list into Microsoft word
If you copy a named range from Excel and paste/link into Word, it might look like this:
[TABLE="width: 253"]
639
642
263
157
641
160
5
288
416
903
701
255
205
82
473
727
536
501
494
550
314
451
160
718
30
[/TABLE]
If you then do Alt+F9 (Toggle Field Codes), the field looks like this:
{LINK Excel.Sheet12 "C"\\somepath\somefile.xlsx" "RawData!wi" \a\f\4 \h}
... where RawData is the name of the worksheet and wi is the named range.
Assuming the named range is dynamic (i.e., it adjusts when data is added or removed), then insertions and deletions in Excel will track when you update fields in Word.
[TABLE="width: 253"]
[/TABLE]