Hi Tony,

I understand I had two ways to do it:
1) Create first a Table in word and format table with three columns and five rows, and then manually encode what my Excel data shows, or
2) Create table in Word by directly embedding the existing file from Excel.

I tried option 2 per your advice and I am getting mixed result. One file I embedded (with data entries up to 18 rows displayed only up to ten rows), though I repeated several times. Meaning that all my Excel data did not show up in the embedded table. I tried another file and lo, the embedded file displayed all rows and columns. Is there a control to what extent of table (rows and column) can be embedded?

Nevertheless, I noticed that when the Excel is embedded in Word, THEN I APPENDED OR EDITED MY DATA IN EXCEL, my data in word does not change but is static. Is there a way to make it dynamic? That as I change data in Excel so it must be auto-reflected in Word. But that looks not possible using the embedding option.

It will be nice if the "linking" - from Excel to Word - will be dynamic and data changes are reflected in "real-time".

Will hear your feedback then.

Waiting,

Kim