WD97: Link to Excel Worksheet Object Not Updated Automatically

WORKAROUND

To update the linked Excel object, use any of the following methods.

Method 1: Update the Field in Word

To update the linked field in Word, follow these steps:

1. Click the object in the Word document.
2. Press F9.

NOTE: This method does not re-establish automatic updating. Each time you modify the Excel worksheet, you must update the Word field using these steps.

Method 2: Close and Reopen the Word Document

1. Start Excel and open the worksheet. Save it.
2. Start Word and open the document that contains the link to the Excel worksheet.

Method 3: Close and Reopen Both Programs

To re-establish automatic updating of the linked fields, follow these steps:

1. Close both Excel and Word.
2. Open Excel and the worksheet that is linked in Word.
3. Open Word and the document containing the Excel links.

NOTE: If you close the Excel worksheet during this session of both Word and Excel, automatic updating will be lost.