Knowledge Base

XL7: Turn Multi-User Editing Off Warning Defaults to Yes

PSS ID Number: 135633

Article Last Modified on 10/22/2000


The information in this article applies to:


This article was previously published under Q135633

SYMPTOMS

In Microsoft Excel, when you clear the Allow Multi-User Editing check box in a shared workbook file, the default button in the dialog box that warns you that this action will prevent others from saving this file is Yes (continue with the action).

CAUSE

This behavior occurs when you stop sharing a workbook file. When you clear the Allow Multi-User Editing check box in the Shared Lists dialog box, you receive a dialog box with the following message:
Warning! This action will prevent other users from saving this file even if you share this file again. Do you want to continue?
By default, the Yes button is selected in this dialog box, so that if you press ENTER, the file is no longer shared. This behavior is by design of Microsoft Excel.

REFERENCES

For more information about creating a shared list in Microsoft Excel, click the Index tab in Microsoft Excel Help, type the following text

   shared lists
				


double-click the selected text and then double-click "Create A Shared List" to go to the "Create A Shared List" topic.

Keywords: KB135633
Technology: kbExcel95 kbExcel95Search kbExcelSearch kbExcelWinSearch