WD97: Link to Excel Worksheet Object Not Updated Automatically

ID: Q185429

The information in this article applies to:
  • Microsoft Word 97 for Windows

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 : kbole kbdta
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbbug


Last Reviewed: August 23, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.