Results 1 to 2 of 2

Thread: Excel to Word

  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    North Carolina, USA
    Thanked 0 Times in 0 Posts
    Is it possible to link numbers from Excel into a Word table such that when Excel is updated it automatically updates the Word table.

    For example, the table is:

    ($ís in Thousands)
    Total Project Cost $
    Total Project Cost +/- Amount included in Current Year Budget $
    Total Project Cost +/- Amount included in Latest Estimate/LE $
    10 Yr Net Present Value $
    Modified Internal Rate of Return (MIRR) %
    MIRR exceed MIRR Hurdle Rate? (Yes/No)(1)
    Payback Period (Yrs)(2)
    Total Benefits: $

    If the numbers are derived in Excel, is there a way to link them to the table above to make dynamic as opposed to being required to copy and paste from Excel to Word?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 58 Times in 58 Posts
    If you insert it as an OLE object it should update automatically when the document is opened in Word the numbers update. Note however that you can't have the Excel document open and also have a word document with the Excel workbook embedded at the same time.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts