Written by Allen Wyatt (last updated June 7, 2023)
This tip applies to Word 2007, 2010, 2013, and 2016
Michael notes that, as he expects, Word automatically updates links when he opens a document. The problem is that when other users of his workbook see the "Do you want to update links" message that appears at startup, they don't understand what is happening. Michael wonders if there is a way to either suppress the message or set the default to "Yes" (to update links) so that the message never appears.
The answer is "yes" and "sort of." (Sounds confusing, right?) You can set the default to yes, but that doesn't guarantee that the users won't be asked again about updates.
If you want to set the default to yes, so that the links will be updated automatically on your machine, you can follow these steps:
Figure 1. The General section of the Advanced options of the Word options dialog box.
With this setting established, your default is established—you want links updated when the document is opened. The problem, of course, is that this is a per-machine setting. As long as someone is using your machine, there is no problem. If you give the document (or series of documents, since there are links between them) to someone else who doesn't have the setting made, then their links won't be updated automatically.
There is one way around this, and that is with an AutoOpen macro. A simple one, to change the one setting, could appear as follows:
Sub AutoOpen() Word.Options.UpdateLinksAtOpen = True End Sub
Of course, such an approach simply replaces one problem with another problem. If your users are confused by being asked about links, then there is just as great a chance that they will be confused when asked if macros should be enabled in the document they are opening.
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (11410) applies to Microsoft Word 2007, 2010, 2013, and 2016. You can find a version of this tip for the older menu interface of Word here: Avoiding the Update Links Message.
Discover the Power of Microsoft Office This beginner-friendly guide reveals the expert tips and strategies you need to skyrocket your productivity and use Office 365 like a pro. Mastering software like Word, Excel, and PowerPoint is essential to be more efficient and advance your career. Simple lessons guide you through every step, providing the knowledge you need to get started. Check out Microsoft Office 365 For Beginners today!
Sections are handy if you want to subdivide a document so you can apply different document formatting to those ...
Discover MoreWhen selecting options within dialog boxes, Word frequently uses drop-down lists to display the options. While ...
Discover MoreThe ribbon, displayed at the top of the Word window, is very handy with all the tools it allows you to access, but it can ...
Discover MoreFREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.
Visit the WordTips channel on YouTube
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments