A co-worker today had a question about embedding an Excel spreadsheet into a Word document file. I looked into it and came up with these steps. The following steps will embed the spreadsheet into the Word document, plus anytime you update the spreadsheet, those changes will be reflected in the Word doc. Here’s the steps:

  1. Open the Excel spreadsheet
  2. Select the cells you want to be embedded
  3. Click the Copy button
  4. Switch to the Word document
  5. Click the insertion point on the Word doc where you want the spreadsheet to be
  6. Click Edit, Paste Special.
  7. Select Microsoft Excel Worksheet Object.
  8. On the left hand side of the Paste Special box, choose the Paste Link radio button (make sure your Excel Spreadsheet is closed at this time)
  9. Click Ok.

Enjoy!

Advertisements