Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Dec 2013
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to keep links in word updated when changing the excel references?

    I currently have a word document that has may links to an external excel sheet. I'm in the process of updating the excel sheet to add/remove date. I need to add/delete some data to the current excel sheet but maintain the links in the word doc.

    For example:
    I have the following link in my word document:
    {LINK Excel.SheetMacroEnabled.12 "C:\\Master_list.xlsm" "Data!R425C4" \a \t}

    I have updated the excel sheet, so the link now needs to reference to Row 430 rather than 425.

    Is there a way I can have word linked to excel so that it knows when an addition or deletion is done to the excel file and updates the link accordingly? So word would automatically update the link to row 430 when I added the rows in the excel sheet?

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Tybo,

    Welcome to the Lounge as a new poster!

    If you use Range names for the data you want linked it will solve the problem in most cases. Worst case you need to update the Range Name in Excel if your editing is too extreeme but you should never have to worry about the Word document.
    { LINK Excel.Sheet.12"Book1" "Sheet1!MyRange" "\a \f5 \h \* MERGEFORMAT }
    HTH :cheers
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    New Lounger
    Join Date
    Dec 2013
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    When I put in a range of cells, the link in word will display all the data within that range. How do I maintain a link to only a specific cell in excel. So that when if i have a link to R10C10, and insert two rows, my word link is now referencing R12C10?

  4. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Tybo,

    You create the Range Name with just that single cell in it. It will automatically move the reference when you insert/delete rows/columns. HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

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