Hi Kim,
Quote:
Originally Posted by KIM SOLIS
The table in Word is just about five to eight columns maximum, though the rows may vary depending on the data population.
|
In that case, provided you set up the LINK field as described in the link Tony posted, all you will need to do for changes to the # or rows is to change the range in Excel to which the named range referred to in the LINK field applies.
You also mention the need for this to be used in:
Quote:
|
a standard company-wide pre-formatted report
|
Do note that the paths in Word's LINK fields are absolute. If you move the Excel file, you'll need to change the link path in Word (eg via Edit|Links). Likewise if you provide the 'automated' report to others for their use - they'll need to change the links to point to their own Excel workbooks (and the named ranges within).