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.
Chapter One. Creating Documents with Microsoft Word 2003
Chapter Two. Formatting and Organizing Text
Chapter Three. Using Graphics and Tables
Chapter Four. Using Special Document Formats, Columns, and Mail Merge
Chapter One. Creating a Worksheet and Charting Data
Chapter Two. Designing Effective Worksheets
Chapter Three. Using Functions and Data Tables
Chapter One. Getting Started with Access Databases and Tables
Chapter Two. Sort, Filter, and Query a Database
Chapter Three. Forms and Reports
Chapter One. Getting Started with PowerPoint 2003
Chapter Two. Creating a Presentation
Chapter Three. Formatting a Presentation
Chapter One. Using Access Data with Other Office Applications
Chapter Two. Using Tables in Word and Excel
Chapter Three. Using Excel as a Data Source in a Mail Merge
Chapter Four. Linking Data in Office Documents
Chapter Five. Creating Presentation Content from Office Documents
GO! with Microsoft Office 2003 Brief (2nd Edition)
Secure Programming Cookbook for C and C++: Recipes for Cryptography, Authentication, Input Validation & More