Computing Staff
  • 0

Word Not Auto Updating Links To Excel

  • 0

I have a Word doc with numerous links to an excel sheet. Although all settings are checked to auto-update links on the Word doc when it loads, and the popup even comes on the screen upon load of the Word doc asking to update the links, none of the links are updated automatically once the file loads. If I ctrl+a then F9, every link will then update, but I need it to do so upon load. Any ideas what I might be doing wrong?

Answer from 2006:
Once the document is loaded, the links will not update. That’s normal behavior. You could create a macro that updates when you run it, which in theory is no different than what you’re already doing.
You can also update before printing if you wish by going to Tools, Options, Print, Printing Options, Update Fields, Update Links.

What do you mean “that’s normal behavior”? I have Word 2010 linked to numerous Excel tables, and it does the same thing, the only way to get it to update automatically is Ctrl-a, then hit F9.

To me, that’s not “Automatically update” links. What’s the purpose of selecting automatically update and the Update links upon opening document preference if it doesn’t work and you end up having to manually update the links by ctrl-1 F9???

Why aren’t there more solutions or even a Microsoft KB solution for this? This feed is the only one I’ve found on the whole web!


2 Answers

  1. Just to say that we can’t possibly comment about what someone happened to say on this forum over seven years ago – for all we know that person is no longer posting. Similarly we can’t say why MS don’t issue KB solutions or why the web doesn’t give hits. We have no control on what MS do or what google finds or not.
    Stick around though, it is quite possible that someone will be able to help with your first paragraph about Office 2010.

    • 0
  2. In Word, try hovering the mousepointer over the linked spreadsheet table,
    right click,
    select “Link macro enabled Worksheet Object” ,
    select Links … , to display the Links dialog.
    Check that the “Update Method for selected link” is set to “Automatic Update”

    • 0