XL97: Application Error Updating OLE Link

ID: Q176252

The information in this article applies to:

Microsoft Excel 97 for Windows

SYMPTOMS

When you click "Close & Return to <Document>", where <Document> is the name of the document that contains the Microsoft Excel worksheet, you may receive an error message similar to the following.

Microsoft Windows 95

   This program has performed an illegal operation and will be
   shut down. If the problem persists, contact the program vendor.

If you click Details, you may receive an error message similar to the following:

   Excel caused an invalid page fault in module Excel.exe at
   015f:3005a618.

Microsoft Windows NT

   Dr. Watson for Windows NT
   An application error has occurred and an application error log is
   being generated.

   Excel.exe

   Exception: access violation (0xc0000005), Address 0x3005a618.

CAUSE

This problem occurs if the following conditions are true:

You have inserted two Excel objects into a document in another program (such as Microsoft Word).
```
    -and-
```
You right-click the embedded Excel object, point to Worksheet Object on the shortcut menu, and then click Open to activate the Excel objects.
```
    -and-
```
One of the Excel objects contains an OLE link to the other Excel object.
```
    -and-
```
The Update Remote References option is enabled.

RESOLUTION

To correct this problem, obtain Microsoft Excel 97 Service Release 2 (SR-2).

For additional information about SR-2, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q151261
   TITLE     : OFF97: How to Obtain and Install MS Office 97 SR-2

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 97 for Windows. This problem was corrected in Microsoft Office 97 Service Release 2 (SR-2).

MORE INFORMATION

Example of the Problem

The following steps illustrate how to reproduce the problem:

 1. Start Microsoft Word 97.

 2. Click Object on the Insert menu. Click Microsoft Excel Worksheet in the
    Object Type box, and then click OK.

    An Excel worksheet object is inserted into your document.

 3. Click the Word document to activate Word.

 4. Click Object on the Insert menu. Click Microsoft Excel Worksheet in the
    Object Type box, and then click OK.

    An Excel worksheet object is inserted into your document.

 5. Click the Word document to activate Word.

 6. Right-click the first embedded Excel object, point to Worksheet
    Object on the shortcut menu, and then click Open.

 7. Activate Word.

 8. Right-click the second embedded Excel object, point to Worksheet
    Object on the shortcut menu, and then click Open.

 9. In Excel, click Copy on the Edit menu.

10. Activate the "Worksheet in Document2" workbook.

11. On the Edit menu, click Paste Special. Click Paste Link, and then click

    "Microsoft Excel 8" in the As box. Click OK.

12. On the File menu, click "Close & Return to Document1."

13. Activate Excel.

14. On the File menu, click "Close & Return to Document1."

You should receive an error message similar to the messages described in the "Symptoms" section of this article.

Additional query words: XL97

Keywords          : kbdta
Version           : WINDOWS: 97
Platform          : WINDOWS
Issue type        : kbbug

Last Reviewed: November 5, 1998