Anatomy of Word: Using Excel information in Word documents

Above, I've pasted the exact same table twice into a Word document. The upper table was pasted with just the "Paste" option while the lower table was pasted with the "Paste Link" option. Afterwards, I updated the Excel information. Note that the upper table did not change when compared with earlier examples in this article. However, the lower table shows updated information.

Note, when you double-click a linked Excel object in Word to edit the contents, Word gives you a full-screen version of Excel to work with and actually loads your Excel file for you. This means that changes made in Word are also transferred back to your original Excel workbook.