Please Note: This article is written for users of the following Microsoft Word versions: 2007, 2010, 2013, 2016, 2019, and Word in Microsoft 365. 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: Changing Document Links.

Changing Document Links

Written by Allen Wyatt (last updated August 10, 2023)
This tip applies to Word 2007, 2010, 2013, 2016, 2019, and Word in Microsoft 365


9

You already know that Word allows you to establish links between your document and other objects, such as graphics, spreadsheets, and other items. There may come a time when you wish to change the links. For instance, you may have an Excel workbook you start over every year. However, the data within the workbook is in the same relative location as the previous year. To update your document for the new year, you can easily change the links established between your document and the worksheet. How you accomplish this depends on the version of Word you are using.

If you are using Word 2007, you do this in the following manner:

  1. Display the Word Options dialog box.
  2. Click Prepare at the left side of the dialog box.
  3. Click Edit Links to Files. (If this option is not available, it means that Word doesn't think there are any links in the current document. Save the document and the Edit Links will then be available.) Word displays the Links dialog box. (See Figure 1.)
  4. Figure 1. The Links dialog box.

  5. Select the link you want to change.
  6. Click on Change Source. Word displays the Change Source dialog box. This dialog box is very similar to a standard Open dialog box in Word.
  7. Use the controls in the dialog box to select the new source for the link.
  8. Click on Open. The Change Source dialog box disappears, and the Links dialog box reappears.
  9. Make any additional link changes necessary by repeating steps 4 through 7.
  10. Click on OK.

If you are using Word 2010 or a later version, follow these steps, instead:

  1. Display the Info option of the File tab of the ribbon. (See Figure 2.)
  2. Figure 2. The Info option of the File tab of the ribbon.

  3. Near the bottom of the right side of the Info screen click Edit Links to Files. (If this option is not available, it means that Word doesn't think there are any links in the current document. Save the document and the Edit Links to Files option will then be available.) Word displays the Links dialog box. (See Figure 3.)
  4. Figure 3. The Links dialog box.

  5. Select the link you want to change.
  6. Click on Change Source. Word displays the Change Source dialog box. This dialog box is very similar to a standard Open dialog box in Word.
  7. Use the controls in the dialog box to select the new source for the link.
  8. Click on Open. The Change Source dialog box disappears, and the Links dialog box reappears.
  9. Make any additional link changes necessary by repeating steps 4 through 7.
  10. Click on OK.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (6007) applies to Microsoft Word 2007, 2010, 2013, 2016, 2019, and Word in Microsoft 365. You can find a version of this tip for the older menu interface of Word here: Changing Document 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

Ensuring Standardized Numbering

Want to make sure your paragraph numbering looks the same on different computer systems? It's a harder task in Word than ...

Discover More

Previous Column Values in a Drop-Down List

Want a quick way to add non-unique values into a column? You probably know you can do this by starting to simply type in ...

Discover More

Centering Your Worksheet

Got just a small amount of worksheet data to print out? It might look better on the printed page if you center it. Excel ...

Discover More

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!

More WordTips (ribbon)

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

Updating Automatic Links

Normally, Word updates links within your document when you first open the document. If you don't want Word to do this, ...

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 ...

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}] (all 7 characters, in the sequence shown) 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 7 - 6?

2023-02-20 14:27:27

Shruti

I have made a word file which consist of several links and i want to update all the links simultaneously trailing to same excel file, however when i select all the links and try to change it gives me dialogue box to choose the change source link for each link, so if im changing the referencing in 20 links it will show me 20 times and each time i have to select in that dialogue box by going to the changed source folder. Any tip to implement changes to one changed link in one go


2022-08-17 10:16:00

Andrew

George, you are probably out of luck using a fields-only solution for relative paths in a LINK field. Looks like you'll need to combine the LINK field with some sort of macro support. This link explains why: https://www.msofficeforums.com/word/38722-word-fields-relative-paths-external-files.html

Andy.


2022-08-16 15:37:13

George Poel

I am desparately looking for a relative link in a WORD document instead of an absolute link.
The EXCEL file I link to is standing is the parent directory of the WORD document.

The object link in WORD is:
{ LINK Excel.Sheet.12 "C:\\Users\\gpo11\\Dropbox\\Stefan\\Vloer isolatie.xlsx" No-Off!R17K3 \a \f 5 \t \* MERGEFORMAT }

I thought { LINK Excel.Sheet.12 "..\Vloer isolatie.xlsx" No-Off!R17K3 \a \f 5 \t \* MERGEFORMAT } should word, but is doesn't.

Kind Regards,

George Poel


2022-02-14 04:01:00

Puca

Do you know how to export this "Links dialog" to an excel file for managing (editing then assigning back) source path, item address then import back to update new link connection? It's especially useful when the item address changed in the link excel files


2020-10-21 23:56:05

Dr Eliahu Farkas

How do I update the source? In other words, I've made changes in the target document. I would like those changes to reflect back into the the source document from which I linked.

I used to do this years ago. Has this feature been discontinued?


2020-01-18 08:17:06

Harber

Did anyone get a solution? I too have this issue. I have many Excel graphs embedded as objects in Word. I just need to update the source file link and NOT the item link.


2019-12-08 16:49:06

Brett Agostini

This works exactly as described. But, here's my problem. Within my Word document, I have MANY linked Excel objects. They are non-adjacent within the Excel worksheet, as well as non-adjacent within the Word document.

This means I must do the procedure you describe MANY times.

But, all the links are to the same file. Is there no way I can just change the FILE referenced?

For example, say all my links from "Monthly Report.doc" are linked to "December Results.xls". At the end of January, I want to change "Monthly Report.doc" so now it looks at "January Results.xls." Is there no way I can do that just by changing the file name somewhere?

(Much like you can change the file referenced for a Mail Merge? I don't need to update every Form Field when I change files on a Mail Merge.)


2019-12-03 16:29:58

Jason Cosman

Did you ever figure out how to mass change the links?


2019-10-31 03:40:33

Qing Hui

how to mass change all the links? Your help is very much appreciated.


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.

Videos
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.