Is it possible to link an Excel File to a Word table?

macropod · #8 09-08-2011, 06:11 AM

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).

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Link in word	chandan56	Office	3	07-02-2015 07:07 PM
Excel data to Word table	Jaymond Flurrie	Word VBA	2	02-27-2011 07:42 PM
link comment to a pivot table	dom585	Excel	0	07-15-2010 11:11 AM
Updating excel link alters table format in PP	dbmagnus	PowerPoint	0	06-03-2010 12:12 PM
Problem creating link to image file	leftylee	PowerPoint	1	04-14-2010 05:49 AM