WD2000: Link to Excel Worksheet Object Is Not Updated Automatically (211770)
The information in this article applies to:
This article was previously published under Q211770 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 is not running when you open the Word document containing
the Excel links.
-or-
- While both Excel and Word are running, you close and reopen the
Excel worksheet, and then make 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 by following these steps.
Method 2: Close and Reopen the Word Document- Save the worksheet.
- Start Word, and then open the document that contains the link to the Excel worksheet.
Method 3: Quit and Restart Both Programs
To re-establish automatic updating of the linked fields, follow these
steps:
- Quit both Excel and Word.
- Start Excel, and then open the worksheet that is linked in Word.
- Start Word, and then open the document containing the Excel links.
NOTE: If you close the Excel worksheet during this session (while both Word and Excel are running), you lose automatic updating.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
| Modification Type: | Major | Last Reviewed: | 12/6/2000 |
|---|
| Keywords: | kbbug KB211770 |
|---|
|