Microsoft KB Archive/185430

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

Article ID: 185430

Article Last Modified on 10/4/2002

-

APPLIES TO


 * Microsoft Word 98 for Macintosh

-



This article was previously published under Q185430





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:


 * 1) Click the object in the Word document.
 * 2) Press F9.

NOTE: This method does not re-establish the 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

 * 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, 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 macword98

Keywords: kbbug kbpending KB185430

-

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

© Microsoft Corporation. All rights reserved.