WD: Link to Excel Worksheet Object Not Updated Automatically (185432)
The information in this article applies to:
- Microsoft Word for Windows 6.0
- Microsoft Word for Windows 6.0a
- Microsoft Word for Windows 6.0c
- Microsoft Word for the Macintosh 6.0
- Microsoft Word for the Macintosh 6.0.1
- Microsoft Word for the Macintosh 6.0.1a
- Microsoft Word for Windows 95
- Microsoft Word for Windows 95 7.0a
This article was previously published under Q185432 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 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: | Minor | Last Reviewed: | 8/18/2005 |
|---|
| Keywords: | kbbug kbpending KB185432 |
|---|
|