Information about any links is saved with the Word document. By default, when you open the document, Word checks the linked files and prompts you to apply any changes.
Open the file Weekly_Sales_Chart_Firstname_Lastname. A message box displays. See Figure 4.4.
The message box asks whether you want to update the data in the document. Click Yes.
When you inserted the Excel chart in the Word document, you selected the Link to file option in Excel. Now you can select other options for how the link to the Excel file will update the Word document.
On the Edit menu, click Links.
The option button for Automatic update is selected by default. When you opened the Word document, it automatically looked at the Excel document for any changes and then updated the data in Word.
More Knowledge: Using Manual Update Instead
If you wanted to use Manual update instead, you could control which file links you wanted to update and when to update them. You would not see the update message box when the document opened.
Click Cancel to leave the selected options as Automatic update.
On the Tools menu, click Options, and then click the General tab.
Save your file, and then Close the file.
This integration project is now complete.
GO! with Microsoft Office 2003 Brief (2nd Edition)
Database Modeling with MicrosoftВ® Visio for Enterprise Architects (The Morgan Kaufmann Series in Data Management Systems)