Please Note: This article is written for users of the following Microsoft Word versions: 2007 and 2010. 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

by Allen Wyatt
(last updated April 25, 2017)

7

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. You do this in the following manner:

  1. Display the Word Options dialog box. (In Word 2007 click the Office button and then click Word Options. In Word 2010 display the File tab of the ribbon and then click Options.)
  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.) 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.

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

Counting the Number of Blank Cells

If you need to count the number of blank cells in a range, the function to use is COUNTBLANK. This tip discusses the ...

Discover More

Applying Bold Italics

Applying bold and italics formatting to text is easy in Word. If you want to apply bold and italics simultaneously, you can ...

Discover More

Incorrect Last Modified Date on E-mailed Documents

Word maintains, in a document's properties, several dates such as the date the document was created and last accessed. Those ...

Discover More

Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!

More WordTips (ribbon)

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

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

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
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 6 - 0?

2017-05-04 10:00:12

Dorian Cosentino

Thanks for the tip.
To help others where is the option in word 2016 see the image (see Figure 1 below)

Figure 1. edit link to files word 2016


2017-05-04 09:56:58

Dorian Cosentino

Thanks for the tip.
To help others where is the option in word 2016 see the image [{fig}]


2017-04-25 05:23:00

Fran

Hello,

I am working with Word 2010, and there is no "Prepare" on the left side of the "Options" dialog - therefore I cannot follow your tip.

Regards,
Fran


2016-11-10 12:09:48

Gina

I have a Word document that contains links to PDFs and Excel documents. If I PDF this Word document and send it out to vendors, will the linked documents (that are located here on network drives) still bring up the PDF or Excel document when they click the link?


2014-12-27 19:18:38

jIM

Rajan, click on one of the linked areas. Then hit Alt+F9. Now do a find and replace of all the locations you're trying to replace.

Thanks,
S


2014-03-04 01:25:59

Rajan

Your Tip is very useful. But i have more than 100 links and it will take so much time to change source of each and every link. Please suggest how i can change source of all links together (in one command).

Your support will be appreciated.


2013-07-16 12:05:29

John McMullen

When you do Change Source on that dialog box, there is a button marked Item. In Word files, the Item seems to be a bookmark name (if you need it). In an Excel file, it's any of a number of things, but all of them are locations--a cell name or range, for instance. I've only found one for Visio, which is Drawing~pagename, where pagename is the name of a page (duh).

Is there a list of these anywhere, for all the different Office programs? It would sure help those of us who try to link them up. I'd love to know if there are additional things you can put in for a Visio document or a PowerPoint slide deck.


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.