+ Reply to Thread
Results 1 to 3 of 3

Macro: Updating all links from Excel in Word at once?

  1. #1
    Registered User
    Join Date
    08-21-2015
    Location
    Brussels, Belgium
    MS-Off Ver
    2013
    Posts
    33

    Macro: Updating all links from Excel in Word at once?

    Hi guys. I have a word document containing 100+ links from an Excel document. The problem is that the links are not automatically updating (which is evidently a common problem). I have made sure that my documents are set up to automatically update, but it still doesn't work. They only way to update them is to right click each and every value in the Word document and click "update link".

    Since I have so many of these links, and I have two frequently update these values, updating each individual link takes a lot of time. One way around this problem is to write a macro that would automatically update each excel-linked value at once. Unfortunately, I'm a brand new beginner in the world of VBA.

    Does someone macro code that they could share?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Macro: Updating all links from Excel in Word at once?

    Have you tried CTRL-A followed by F9? That is only two keystrokes, might not not be any harder than a macro.

    What kind of problem are you having with automatic updates? If both files are open, the Word file should update as the Excel file is changed. If not, then the Word file should offer an option to do the updates when you open it.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Macro: Updating all links from Excel in Word at once?

    Have you tried CTRL-A followed by F9? That is only two keystrokes, might not not be any harder than a macro.

    What kind of problem are you having with automatic updates? If both files are open, the Word file should update as the Excel file is changed. If not, then the Word file should offer an option to do the updates when you open it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Word 2007 vs 2013 Updating Links
    By ptmuldoon in forum Word Formatting & General
    Replies: 0
    Last Post: 09-13-2014, 09:00 AM
  2. NOT update External Links when opening a word document via excel macro
    By debbie2852 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-08-2013, 04:49 PM
  3. Updating macro links
    By mungel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-25-2011, 02:22 PM
  4. Excel Links Not Updating, But All Links status are ok
    By DJPROLE in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-04-2011, 10:44 AM
  5. Updating links to word doc based on filename?
    By Bobblybook in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-24-2011, 10:56 PM
  6. Updating Excel Links using Macro HELP!
    By test1986 in forum Excel General
    Replies: 1
    Last Post: 10-24-2006, 10:22 AM
  7. Updating Links During Macro
    By SteveKak in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-04-2005, 11:13 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1