XL97: Application Error Updating OLE Link

• 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.

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:

Q151261 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

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."

Additional query words: XL97

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