Article ID: 176252
Article Last Modified on 9/22/2005
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q176252
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
If you click Details, you may receive an error message similar to the following:
Microsoft Windows NT
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:
151261 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:
- Start Microsoft Word 97.
- 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.
- Click the Word document to activate Word.
- 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.
- Click the Word document to activate Word.
- Right-click the first embedded Excel object, point to Worksheet Object on the shortcut menu, and then click Open.
- Activate Word.
- Right-click the second embedded Excel object, point to Worksheet Object on the shortcut menu, and then click Open.
- In Excel, click Copy on the Edit menu.
- Activate the "Worksheet in Document2" workbook.
- On the Edit menu, click Paste Special. Click Paste Link, and then click "Microsoft Excel 8" in the As box. Click OK.
- On the File menu, click "Close & Return to Document1."
- Activate Excel.
- 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: kbbug kbqfe kbhotfixserver KB176252