About Word Training Manual for Word 2003
Word Training Manual
About Word Training Manual News Home
Archives
Category Index


Word Training Manual : About Word Training Manual News Home : September 2006

Linking Excel to Word 2003.


Inserting Excel worksheets in a Microsoft Word 2003 document.


The mathematical functionality within tables in Microsoft Word 2003
is quite limited. For instance having entered a sum(above) formula if we then
change a cell content the "sum" does not refresh.
For more complicated calculations it is advisable to perform the calculation in
a Microsoft Excel 2003 Worksheet and insert it in Word 2003.


This can be done by any of three methods:
  • Copying and Pasting

  • Embedding

  • Linking

  • The question now is which method do we use to insert an Excel Worksheet
    into a Word 2003 document.


    The method used depends very much on whether the data from the source i.e. Excel
    needs to update the destination file i.e Word 2003.


    If the data does not have to be updated then the Copying and Pasting method will
    suffice as this method does not "Connect" both files.
    If the data does have to be updated then use either the Embedding or Linking method.

    (Go to URL)

    August 2006 «  » November 2006