E-Mail:

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.

What Do You Think?

 

Want to Start a Blog Here for Free?

Are you an expert in one subject or another? If your goal is to help others and dispense hard-earned information back to the community, stake a claim on your very own Lockergnome blog today! You can write about anything - no matter the topic. Sign-up to start blogging!

Favorite - Oct 10, 2008

Scour

Download, Freeware - Oct 9, 2008

CurrPorts v1.51

Download, Freeware - Oct 6, 2008

AudioGrail v6.13.2.158

Download, Freeware - Oct 3, 2008

SniffPass v1.07

83 queries / 2.208 seconds.