View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
flummi
 
Posts: n/a
Default Update Excel links in Word

Instead of copy and paste you can insert a linked object from an Excel
workbook into your word document. That is always updated when you open
the document and you can also update it manually at any point in time.
Plus when you double click it it will open Excel and lets you make any
required changes which are immediately updated in your Word object.

Look into the Word help under "embed" and there under Use linked and
embedded objects. Important is, when you select the workbook, to check
the "link to file" checkbox.

If you need mre assitance come back please.

Hans