Microsoft KB Archive/185432

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

Article ID: 185432

Article Last Modified on 11/1/2006

-

APPLIES TO


 * Microsoft Word 6.0 Standard Edition
 * Microsoft Word 6.0a
 * Microsoft Word 6.0c
 * Microsoft Word 6.0 for Macintosh
 * Microsoft Word 6.01 for Macintosh
 * Microsoft Word 6.01 for Macintosh
 * Microsoft Word 95 Standard Edition
 * Microsoft Word 95a

-



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:


 * 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 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 pastelink paste-link paste link

Keywords: kbbug kbpending KB185432

-

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

© Microsoft Corporation. All rights reserved.