Automatically Updating Excel Data In Word Doc Inside Excel File

Discussion in 'Microsoft Excel Misc' started by Guest, Aug 29, 2004.

  1. Guest

    Guest Guest

    I have inserted a "Word" object icon into an Excel file (Tab 1) and then used
    paste link to display data updates from other tabs in the same Excel file in
    the Word document that is in Tab 1. I am looking for a way to have the links
    from the Excel Tab 1 file that are in the Word file automatically updated and
    independent of the Excel filename.

    Problem is that when I put the Word document icon into the Excel file, open
    it, paste link data from the same Excel file and then rename the Excel file
    later the links are not automatically reflecting the new Excel name. The new
    Excel file name is showing "invalid link" references when I open the Word
    document inserted in the original file.

    I would appreciate anyone's assistance to find a workable solution so that I
    don't have to have users trying to manually changing file links everytime
    they rename their baseline Excel file that has the inserted Word document.

    Thanks, David
     
    Guest, Aug 29, 2004
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Normand
    Replies:
    0
    Views:
    486
    Normand
    Jul 14, 2003
  2. Guest

    hyperlink in Excel to Word doc closes Excel doc

    Guest, Mar 16, 2005, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    271
    Guest
    Mar 17, 2005
  3. Guest

    Imbed Linked Word doc in Excel so whole doc shows?

    Guest, May 17, 2005, in forum: Microsoft Excel Misc
    Replies:
    3
    Views:
    248
    Dave Peterson
    May 17, 2005
  4. Guest

    convert a Word doc into an Excel doc.

    Guest, Jul 28, 2005, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    300
    Guest
    Jul 28, 2005
  5. Guest
    Replies:
    3
    Views:
    330
    Guest
    Aug 24, 2005
  6. Guest

    Macro to copy a word doc into an excel doc

    Guest, Feb 22, 2006, in forum: Microsoft Excel Misc
    Replies:
    0
    Views:
    313
    Guest
    Feb 22, 2006
  7. Guest

    MERGING DATA FROM TWO DOC INTO ONE DOC

    Guest, Oct 30, 2006, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    229
    Guest
    Oct 30, 2006
  8. frank mcdonough

    A line in the middle of my doc causes Word to treat one doc as two

    frank mcdonough, Jan 3, 2008, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    217
    Gord Dibben
    Jan 3, 2008
Loading...