Microsoft KB Archive/211770

= WD2000: Link to Excel Worksheet Object Is Not Updated Automatically =

Article ID: 211770

Article Last Modified on 12/6/2000

-

APPLIES TO


 * Microsoft Word 2000 Standard Edition

-



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:


 * 1) Click the object in the Word document.
 * 2) 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

 * 1) Save the worksheet.
 * 2) 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:
 * 1) Quit both Excel and Word.
 * 2) Start Excel, and then open the worksheet that is linked in Word.
 * 3) 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.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: cut chart interoperability OLE table

Keywords: kbbug kbpending KB211770

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.