If I have a table in Excel that is, for example, 4 rows by 2 columns, copy
this table and paste special an Excel link in Word, I have a linked table
displayed in Word. Now, if I change the table in Excel by adding a row so
that it is now 5 rows by 2 columns, the table in word still displays 4 rows
by 2 columns. Is there any way of having this change automatically (the
table view in Word expand to 5 rows by 2) without having to copy and paste
every table I change?

What is worse is if there are multiple tables from one Excel sheet pasted
(individually) into Word and you insert a row somewhere above them - the
tables in Word are all offset by one (i.e. the table header is moved down one
and you lose the bottom row of the table).

Any suggested solutions? I assume the solution includes creating dynamic
links rather than static links, but I'm not sure how.

Thanks in advance,
James