MS table autofill from Excel

J

James Tristram

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

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

Thanks
 
S

Stefan Blom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embedded Excel into Word with Tables 0
Embed the same Excel multiple times 0
Consolidation Table from Different Excel Tabs with Different Format 1
Paste to excel from word - auto format problem 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Linking data in MS Word into Excel 5
Merging from an Excel file with graphics 1
Error related to trying to compare Word docs in 2010 2

Top