Tip of the Day Blog
    The Web
« Best Free Reference Web Sites 2004 | Main | 8 New Inkjet Printers Put to the Test »

Importing Excel Data Into Word 2002 By Creating A Dynamic Link

There are several different ways that you can copy data from Excel into Word. The method you choose will depend on the functionality you want to retain once the data has been imported. For example, if you do a simple copy and paste, you can edit the imported Excel data as any other Word table. However, if you want to be able to edit that data within Excel and have those changes updated automatically in Word, you can do so by creating a dynamic link.

  1. Open your Word document.
  2. Open your Excel spreadsheet.
  3. With Excel, select the cells you want to copy into Word.
  4. From the Edit menu, click Copy.
  5. Switch back to your Word document.
  6. Place the insertion point where you want the data placed.
  7. From the Edit menu, click Paste Special.
  8. Select Microsoft Excel Worksheet Object.
  9. Select the Paste Link radio button.
  10. Click OK.

Now when you double click the table in Word, the worksheet will open in Excel.

EmailEmail Article to Friend