Anatomy of Word: Using Excel information in Word documents
Note that the "Paste Link" option is chosen this time
Paste special (Paste LINK: Excel Worksheet Object)
Suppose you've copied a portion of a larger Excel document into your Word table for various reports, but the Excel information is under constant modification. If you use just the Paste Special method above, you'll spend a lot of time synchronizing the information in Word with you Excel data. Fortunately, Microsoft considered this predicament and provides a very simple solution.
The solution is almost identical to the Paste Special option I talked about in the previous section except for one key factor. In the Paste Special window, rather than choosing the Paste radio button at the left side of the screen, choose the "Paste link" option instead.
Suppose you've copied a portion of a larger Excel document into your Word table for various reports, but the Excel information is under constant modification. If you use just the Paste Special method above, you'll spend a lot of time synchronizing the information in Word with you Excel data. Fortunately, Microsoft considered this predicament and provides a very simple solution.
The solution is almost identical to the Paste Special option I talked about in the previous section except for one key factor. In the Paste Special window, rather than choosing the Paste radio button at the left side of the screen, choose the "Paste link" option instead.
