View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Richard O. Neville
 
Posts: n/a
Default Problem inserting Excel data into Word

It definitely is possible. Copy the data from Excel and switch to Word, but
don't just paste, select Edit-Paste Special and check the "Paste link" box,
which will provide other choices. Then any change made in the source Excel
sheet will update in Word. Test it a time or two to make sure it's working
right.

"Philamental" wrote in message
...
Hello,

Apologies if I am posting this to the wrong group.

My colleague has a number of Excel worksheets that he has done a number of
calculations on. He needs to insert this data into Word as part of a
Report he is preparing. That part is straight forward enough.

However, he is looking for a solution whereby if he updates the Excel
sheet it automatically updates the part he has inserted into Word.

Is this even possible? If it is, could someone outline the procedure, or
link me to a relevant article.

Thank you,

Phil