Word excel link update frequency/ Interval

Update linked objects

By default, linked objects are updated automatically. This means that Word updates the linked information every time you open the Word file or any time the source Excel file changes while the Word file is open. However, you can change the settings for individual linked objects so that the linked object is not updated or so that it is updated only when the reader of your document chooses to manually update it.

You can also prevent Word from automatically updating links in all the documents that you open. You can do this as a security measure, to prevent updating documents with files that are potentially from an untrusted source.

 Important   When you open a document that contains linked objects, Word prompts you to update the document with data from the linked files. If you suspect that the linked files may be from an untrusted source, click No in this message.

In addition, you can permanently break the connection between a linked object and its source Excel file. When the connection is broken, you can no longer edit the object in the Word document; it becomes a picture of the Excel content.

Manually update a linked object

1. Click the Microsoft Office Button , point to Prepare, and then click Edit Links to Files.

2. Click the link that you want to update manually, and then under Update method for selected link, click Manual update. Or press CTRL+SHIFT+F7.

Prevent a linked object from being updated

1. Click the Microsoft Office Button , point to Prepare, and then click Edit Links to Files.

2. Click the link that you want to prevent from being updated, and then under Update method for selected link, select the Locked check box. Or press F11.

 Note   To unlock the link, click the linked object, and then press CTRL+SHIFT+F11.

Prevent Word from automatically updating links in all documents

1. Click the Microsoft Office Button , and then click Word Options.

2. Click Advanced, and then scroll down to General.
3. Clear the Update automatic links at Open check box.

To update all Unformatted Text in the documents 

Simply update the appropriate fields in Word by clicking on the field and pressing F9; alternatively, select the entire document by pressing CTRL + A and then press F9 to update all fields.