Insert Excel cells Word Table BUT Fit?

[markg2]

I wish to insert (paste special/Object/Link) 3 columns of an Excel worksheet (the 3rd column having values and an addition formula at the bottom) into an existing Word table.


I've tried this many times before and have given up trying to figure out how to get the imported data to 'fit' properly within the target cell.


Two questions:


1. Would someone provide an information link that explains how to do the above wherein Word/Excel will automatically adjust in size and format?


2. Does the source Excel file and the target Word file need to be in the same directory for the Word table to automatically adjust to changes in the Excel cells?




Thanks,


Mark