Objective 3. Open a Word Document That Includes a Linked Object, and Update Links

Activity 4.3. Opening a Word Document That Includes a Linked Object

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.

[Page 1379]

Figure 4.4.


The message box asks whether you want to update the data in the document. Click Yes.

Any changes made to the Excel file will be changed in the Word object as well. This is an automatic update.

Activity 4.4. Updating a Linked Object

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 Links dialog box opens. See Figure 4.5.

Figure 4.5.

[Page 1380]
The file path for the linked Excel file displays under Source file.

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.

In the options, check that automatic update for links is also selected.


On the Tools menu, click Options, and then click the General tab.

Under General options, the Update automatic links at Open check box should be selected. See Figure 4.6.

Figure 4.6.


Click OK.


Save your file, and then Close the file.


This integration project is now complete.

[Page 1381]

Windows XP

Outlook 2003

Internet Explorer

Computer Concepts

Word 2003

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

Excel 2003

Chapter One. Creating a Worksheet and Charting Data

Chapter Two. Designing Effective Worksheets

Chapter Three. Using Functions and Data Tables

Access 2003

Chapter One. Getting Started with Access Databases and Tables

Chapter Two. Sort, Filter, and Query a Database

Chapter Three. Forms and Reports

Powerpoint 2003

Chapter One. Getting Started with PowerPoint 2003

Chapter Two. Creating a Presentation

Chapter Three. Formatting a Presentation

Integrated Projects

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
GO! with Microsoft Office 2003 Brief (2nd Edition)
ISBN: 0131878646
EAN: 2147483647
Year: 2004
Pages: 448

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net