Hello MSOfficeForums. I inserted Excel in Word to facilitate mathematical calculations. The data source is located in an excel workbook. Is there a way to link the excel that I inserted in Word with the data in the excel file so that any changes in the source book will be reflected in the word file? Thanks.

Simply copy the Excel range and paste it into Word using Paste Special, with the 'paste link' option and your preferred paste format.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you Paul, the paste link option solved it. A problem arises when a row is inserted in the source data but I could happily work with that rather than the tedious encoding of hundreds of accounts every quarter of the year.

If you name the Excel range before copying/pasting, the link will reflect any changes to the rows & columns spanned by that range name.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I need to insert a row in Word then copy down the formula. Thank you!!!

That suggests you're trying to copy individual cells and paste them into a table. Instead, simply copy the entire range in Excel and paste that into Word as a table.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Post #2 meets my requirements better because the Excel table has more columns than the Word table. I tried vlookup but it seems Word does not recognize formulae.

You still only need to copy & paste the columns required as a single entity. If there are intermediate columns you don't want, you should consider re-arranging the worksheet or creating a new one with just the ranges you're interested in from that worksheet, so the lot can be copied & pasted into Word as a single entity.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I will try this. Again, thank you.