Control when Word 2007 updates links

When you open a document, Word automatically updates any linked objects it contains, such as worksheet data. If you'd rather handle the process yourself, follow these steps to configure Word for manual updates.

If your monthly report includes a copy of the updated inventory figures from one Excel worksheet, you can save yourself some time by establishing a link to the original data. That way, you won't have to copy and paste it each month. By default, Word automatically updates data in a linked object when you open the Word file or when changes are made to the source data while the Word file is open. However, if you only need the table updated just before you send it to the printer, you can change Word settings so you can manually control the update.

Follow these steps:

  1. Click the Office button.
  2. Click the Word Options button.
  3. Click Advanced.
  4. Under General, clear the Update Automatic Links At Open check box (Figure A).

Figure A

advanced options

Now when you open the document, you won't receive a message asking whether Word should update the information in the linked object. Additionally, while your document is open, the source file can be opened only in read-only mode; no changes can be made to the linked objected or the source while the Word file is open.

When you're ready to update the data in the linked spreadsheet, follow these steps:

  1. Click the Office button.
  2. Point to Prepare.
  3. Scroll down and click Edit Links To Files (Figure B).

Figure B

manual update

  1. Under Update Method For Selected Link, select the Manual Update check box and click OK (Figure C).

Figure C

update method

Miss a Word tip?

Check out the Microsoft Word archive and catch up on other Word tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.


I want to update a link that is in ppt while someone else is working in the original work document. It won't let me open up the file except as a read only. Any help would be appreciated.


I do not have the menu option of edit links to file under the Prepare menu. How do I get this option? Please advise.


Even with these steps done, Word still seems to be "examining" all my links when I open a document which makes it very slow. The evidence is that I opened an C:\folderA\source.xlsm first and then I opened a Word doc that has a link to C:\folderB\source.xlsm. I got an error message about trying to open two files with the same name. If Word were not updating or "examining" the links, it wouldn't even need to open source.xlsm. (My end goal was to open the doc and then change the link to point to the file in the new folder.) In 2003 turning off automatic links seemed to work. In 2007 it seems to only turn off changes but not checking of links.


Why does word suddenly start blacking your words no matter what you do to get rid of it. If you want to save it, it will save every file you have in word so the only way I can save my file and shut down word is to use "Save As" then I have to go to another step and shut down the computer then start up again to free me of this problem so I can go back into word again. What is wrong?


insert some links.

Editor's Picks