[James Tristram]

Hello,
For work I have a number of tables within MSWord report templates that are filled in from data collected into excel spreadsheets.

Is it possible for the excel spreadsheets to be linked to the word tables so that when both files are in the same folder, the word tables are automatically updated?

Thanks!

[Stefan Blom[_3_]]

Select a range in the Excel file and copy it. In Word, use the Paste
Special dialog box to paste the data as a link; this results in an
automation object (sometimes referred to as OLE), which can be updated.

--
Stefan Blom
Microsoft Word MVP



On 2012-06-14 14:56 (GMT+1), James Tristram wrote:
Hello,
For work I have a number of tables within MSWord report templates that
are filled in from data collected into excel spreadsheets.

Is it possible for the excel spreadsheets to be linked to the word
tables so that when both files are in the same folder, the word tables
are automatically updated?

Thanks!