linking Excel table to word

T

Thrava

Can anyone tell me how I can have an excel table linked to
a word table so that the word table dynamically updates
itself based on the values in excel cells?

Much appreciate it if anyone can point me to direction
Thrava
 
F

Frank Kabel

Hi
in MS Word just insert the Excel sheet as Excel object (Edit - Paste
Special)
 
M

macropod

Hi Thrava,

As Frank says, you can use Edit|Paste Special to paste the required part of
the worksheet into Word. If you use the 'paste link' option that comes with
Edit|Paste Special, the Word table can be set to update as the data in the
Excel file changes.

You also have a number of paste format options available via Edit|Paste
Special. If you need to insert the Excel data into particular cells in an
existing Word table, select the Excel cells one at a time and use 'Formatted
text (RTF)' when pasting them into the Word table cells.

Cheers
 
Top