WD97: Link to Excel Worksheet Object Not Updated Automatically (185429)
The information in this article applies to:
- Microsoft Word 97 for Windows
This article was previously published under Q185429 SYMPTOMS
When you make changes to a Microsoft Excel worksheet that is linked
to a Microsoft Word document, the changes may not be automatically
updated in the document.
CAUSE
This problem may occur if either of the following is true:
- Excel was not running when you opened the Word document containing
the Excel links.
-or-
- While both Excel and Word were open, you closed and reopened the
Excel worksheet and then made a change to the worksheet.
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:
- Click the object in the Word document.
- 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- Start Excel and open the worksheet. Save it.
- 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:
- Close both Excel and Word.
- Open Excel and the worksheet that is linked in Word.
- 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.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft
products listed at the beginning of this article.
| Modification Type: | Major | Last Reviewed: | 11/14/2000 |
|---|
| Keywords: | kbbug KB185429 |
|---|
|