The information in this article applies to:
SYMPTOMSIn Microsoft Excel, when you double-click an embedded object on a worksheet that you have stopped sharing, you may receive an illegal operation error message. When you click Details, a message similar to the following appears: -or-
CAUSEThis problem occurs if you perform each of the following actions without closing the workbook between actions:
Note that you cannot edit or insert an object in a shared workbook. You must stop sharing the workbook before you can edit or insert an embedded object. However, if you have not closed the workbook since you inserted the object, you receive an illegal operation error message if you stop sharing the workbook, and then double-click the object. WORKAROUNDSTo work around this problem when you share a workbook that contains an embedded object, and then want to edit the object, use any of the following methods:Method 1:Close the workbook, and open the workbook again before you clear the Allow Multi-User Editing check box in the Shared Lists dialog box. Method 2:Clear the Allow Multi-User Editing check box in the Shared Lists dialog box, close the workbook, and then open the workbook again before you edit the object. Method 3:Use the Open or Edit command to edit the object instead of double-clicking the object by doing the following: STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available. REFERENCESFor more information about sharing a list on your worksheet in Microsoft Excel, click the Index tab in Microsoft Excel Help, type the following text shared lidouble-click "Sharing A List With Other People" and then double-click the selected text to go to the "Sharing A List With Other People" topic. Additional query words: crash shut down
Keywords : xlwin |
Last Reviewed: October 1, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |