Microsoft KB Archive/185429

= WD97: Link to Excel Worksheet Object Not Updated Automatically =

Article ID: 185429

Article Last Modified on 1/23/2007

-

APPLIES TO


 * Microsoft Word 97 Standard Edition

-



This article was previously published under Q185429





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 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 and then made 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 using these steps.

Method 2: Close and Reopen the Word Document

 * 1) Start Excel and open the worksheet. Save it.
 * 2) 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:


 * 1) Close both Excel and Word.
 * 2) Open Excel and the worksheet that is linked in Word.
 * 3) Open Word and the document containing the Excel links.

NOTE: If you close the Excel worksheet during this session of both Word and Excel, 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

Keywords: kbbug kbpending KB185429

-

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

© Microsoft Corporation. All rights reserved.