WD: Link to Excel Worksheet Object Not Updated Automatically

ID: Q185432

The information in this article applies to:

• Microsoft Word for Windows, versions 6.0, 6.0a, 6.0c
• Microsoft Word for the Macintosh, versions 6.0, 6.0.1, 6.0.1a
• Microsoft Word for Windows 95, versions 7.0, 7.0a

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          : kbole kbdta
Version           : MACINTOSH:6.0,6.0.1,6.0.1a; WINDOWS:6.0,6.0a,6.0c,7.0,7.0a
Platform          : MACINTOSH WINDOWS
Hardware          : MAC x86
Issue type        : kbbug
Solution Type     : kbpending

Last Reviewed: February 11, 1999