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!