WD98: Link to Excel Worksheet Object Not Updated Automatically (185430)
The information in this article applies to:
- Microsoft Word 98 Macintosh Edition
This article was previously published under Q185430 SYMPTOMS
When you make changes to a Microsoft Excel worksheet that is linked
to a Microsoft Word document, the changes are not automatically
updated in the document.
CAUSE
This problem occurs if either of the following are 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.
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 the automatic updating. Each
time you modify the Excel worksheet, you will need to 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, the 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: | 10/4/2002 |
|---|
| Keywords: | kbbug KB185430 |
|---|
|