Please Note: This article is written for users of the following Microsoft Word versions: 2007, 2010, 2013, and 2016. If you are using an earlier version (Word 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Word, click here: Updating Automatic Links.

Updating Automatic Links

by Allen Wyatt
(last updated February 18, 2017)

3

You already know that Word allows you to include many different elements in your documents, such as pieces of Excel worksheets, sounds, graphics, and other objects. You may even know that you can establish active links with these objects so that any changes in the objects can be reflected in your document, as well. You may not know, however, that you can control whether Word automatically updates links when you open a document. You control this feature in this manner:

  1. Display the Word Options dialog box. (In Word 2007 click the Office button and then click Word Options. In Word 2010 and later versions display the File tab of the ribbon and then click Options.)
  2. At the left side of the dialog box click Advanced.
  3. Scroll through the available options until you see the General section. (See Figure 1.)
  4. Figure 1. The advanced options of the Word Options dialog box.

  5. Set the Update Automatic Links At Open check box as you desire.
  6. Click OK.

Why would you not want to automatically update links when you open a document? The chief reason is time—if your document contains quite a few links, or if the source of those links is hard to reach (perhaps through a network), then opening your document can be extremely slow. To speed up opening your document, turn off automatic updating and things should be fine. Of course, if you want to make sure you have the latest updates of your linked objects, you will need to update them manually, or simply turn on the option and reopen your document.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (6115) 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: Updating Automatic Links.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Wrapping Spaces

Add more than one space after the end of a sentence, and you may find that the extra spaces wrap to the start of new lines. ...

Discover More

Converting Text to Numbers

Import information from a program external to Excel, and your numbers may be treated as text because of the way that the ...

Discover More

Quickly Deleting Rows and Columns

Deleting rows or columns is easy when you use the shortcut described in this tip. Just select the rows or columns and then ...

Discover More

The First and Last Word on Word! Bestselling For Dummies author Dan Gookin puts his usual fun and friendly candor back to work to show you how to navigate Word 2013. Spend more time working and less time trying to figure it all out! Check out Word 2013 For Dummies today!

More WordTips (ribbon)

Changing Document Links

If your document contains links to information in other documents, you can modify the source document that is linked to ...

Discover More

Accessing the Source of a Document Link

If you have information linked into your document, you may want to display the source of that linked information. Word ...

Discover More

Breaking a Document Link

Word allows you to link external information into your documents. If you no longer need to maintain the active link, you can ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 9 - 2?

2017-03-29 14:20:30

Bud Staniek

This tip does not work as Allen describes. I have a Word doc with links to multiple Excel files that I would LOVE to open without it updating the links. I un-checked the 'Update automatic links at open' option, saved, and closed the file. When I re-opened it, it still proceeded to refresh the links. The only thing the changed setting did was to suppress the dialog that asks you "Do you want to update this document with the data from the linked files?” Granted that dialog is annoying and I don't miss it, but I would really like to stop the doc from updating the links at open.


2014-09-03 11:39:54

Marilyn Bohnaker

Update automatic links at open doesn't seem to work when I copy the document with internal links (ie. Customer Name on top, name automatically reflected on on signature line) to another location. How can I correct this. I do have "Update automatic links at open" checked.


2014-05-15 11:59:04

Joel

I use Office pro 2010 with Word version 14.0.7515.1000 (32-bit)
With word document even if I put all my links in manual and I deselect "update automatic link at open" word check all links (without updating them) when I open a document.
the issue is that I have a document with more than 200 links with 13 big excel files and not to waste time I have to open all the excel files (~ 20 min to open)
Can you help me ?
thank a lot


This Site

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.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.