WD: Link to Excel Worksheet Object Not Updated Automatically
ID: Q185432
|
The information in this article applies to:
-
Microsoft Word for Windows, versions 6.0, 6.0a, 6.0c
-
Microsoft Word for the Macintosh, versions 6.0, 6.0.1, 6.0.1a
-
Microsoft Word for Windows 95, versions 7.0, 7.0a
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.
Additional query words:
cut chart interoperability OLE table pastelink paste-link paste link
Keywords : kbole kbdta
Version : MACINTOSH:6.0,6.0.1,6.0.1a; WINDOWS:6.0,6.0a,6.0c,7.0,7.0a
Platform : MACINTOSH WINDOWS
Issue type : kbbug