XL7: Save As Dialog Box Saves File Without Multi-User Editing

Last reviewed: September 13, 1996
Article ID: Q129993

The information in this article applies to:

  • Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In Microsoft Excel, when you save a file that has the Multi-User Editing feature turned on, this feature may not be turned on in the saved file.

CAUSE

This behavior occurs when you use the Save As command on the File menu to save the file, and you change either the file format or the filename. If you change the file format, the Multi-User Editing feature is not turned on in the new file, because you can only share a Microsoft Excel Workbook file.

For additional information, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q129444
   TITLE     : XL7: 'Save As Type' Box Contains Only Excel Workbook

If you change only the filename, the Multi-User Editing feature is not turned on in the new file. This behavior is by design, because normally, when you save a shared file, you do so to make your own local copy. Therefore, the Multi-User Editing feature is not "saved" to the new copy of the file.

WORKAROUNDS

To work around this behavior, you can turn on the Multi-User Editing feature in the new file by doing the following:

  1. On the File menu, click Shared Lists, and then click the Editing tab.

  2. Click the Allow Multi-User Editing check box.

Note that if the format of this file is not Microsoft Excel workbook, the Save As dialog box appears, and you must save the file in the Microsoft Excel workbook format in order to save the file with the Multi-User Editing feature turned on.


KBCategory: kbnetwork
KBSubcategory: xlwin

Additional reference words: 7.00



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: September 13, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.