XL7: 'Save As Type' Box Contains Only Excel Workbook

Last reviewed: March 27, 1997
Article ID: Q129444
7.00 WINDOWS kbother xlwin

The information in this article applies to:

  • Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In Microsoft Excel, when you click the "Allow Multi-User Editing" check box on the Editing tab of the Shared Lists dialog box, the Save As dialog box may appear with Microsoft Excel Workbook as the only option listed in the Save As Type box.

CAUSE

This behavior occurs when you click the "Allow Multi-User Editing" check box in a workbook that has not been saved or that is saved in a file format other than Microsoft Excel workbook. This behavior is by design, because you cannot share a file in Microsoft Excel unless it is saved in the Microsoft Excel workbook file format. Additionally, you cannot save a file in Microsoft Excel to a file format other than Microsoft Excel workbook and still maintain the Allow Multi-User Editing feature.

MORE INFORMATION

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

   ARTICLE-ID: Q129993
   TITLE     : XL7: Save As Dialog Saves File Without Multi-User Editing

When you click the "Allow Multi-User Editing" check box in a Microsoft Excel workbook file, you receive a dialog box with the following message:

   This operation will result in a save. Continue?

When you choose OK, the file is saved again as a Microsoft Excel workbook, and the Multi-User Editing feature is enabled.

However, when you click the "Allow Multi-User Editing" check box in a file that has not been saved or in a file that has been saved in a file format other than Microsoft Excel Workbook, the Save As dialog box appears as described above. If you do not save the file as a Microsoft Excel workbook file, the Multi-User Editing feature is not enabled for the file.


KBCategory: kbother
KBSubcategory: xlwin

Additional reference words: 7.00
Keywords : xlwin kbother
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.