If you configure the Excel workbook so that the data the Word document are to reference are always in the same location (eg by having a separate worksheet where the reference data appear), you can create links by copying the Excel cells, then pasting the content into Word using Paste Special with the 'paste link' option. Note that several paste formats are supported. Experiment to see which format(s) best suit your needs.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|