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

 Last reviewed: March 27, 1997
Article ID: Q135633
7.00 WINDOWS kbnetwork

The information in this article applies to:

  • Microsoft Excel for Windows 95, version 7.0

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.

KBCategory: kbnetwork
KBSubcategory: xlwin

Additional reference words: 7.00
Keywords : xlwin kbnetwork
Version : 7.00
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 27, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.