Im attempting to copy and paste a portion of an Excel 2007 worksheet into a
Word 2007 document, using the Paste Link option. My understanding is that if
you change data in the worksheet, the changes will automatically be made in
the Word document, even if the Word document is open. It is not working that
way. I can right-click the Excel object in the Word document and select
Update Link. The data then updates properly. Also, if I close the Word
document and re-open it, Im prompted to update the link, and the updates
show properly. Should the linked Excel object in the Word document be
updated automatically, even if the Word document is open?