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. Guest

    hyperlink in Excel to Word doc closes Excel doc

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

    Imbed Linked Word doc in Excel so whole doc shows?

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

    convert a Word doc into an Excel doc.

    Guest, Jul 28, 2005, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    219
    Guest
    Jul 28, 2005
  4. Guest
    Replies:
    3
    Views:
    246
    Guest
    Aug 24, 2005
  5. Guest

    Macro to copy a word doc into an excel doc

    Guest, Feb 22, 2006, in forum: Microsoft Excel Misc
    Replies:
    0
    Views:
    214
    Guest
    Feb 22, 2006
Loading...

Share This Page