Linking to a named range would seem a possible answer, but I suspect
that the size of the picture of the range in Word will not change, even
if more rows of data are available through it.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup