Excel Err Msg: Sheet Is Protected...Format Cannot Be Used

 Last reviewed: November 30, 1994
Article ID: Q80228
The information in this article applies to:
  • Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a, 5.0
  • Microsoft Excel for the Macintosh, versions 3.0, 4.0, 5.0

SUMMARY

When you attempt to save a password-protected document from the versions of Microsoft Excel listed above, Excel generates the error message: 

   Sheet is protected with password. File format cannot be used.
If this message occurs and the document must be saved in the Excel 2.x format as protected with a password, do the following:

  1. From the Options menu, choose Unprotect Document, enter the password, and choose the OK button. (In Excel 5.0 select Protection from the Tools menu and then choose unprotect sheet.)

  2. Save the document in Excel 2.x format. (From the File menu, choose Save As, choose the Options button, and under File Format, select Excel 2.x).

  3. From the Options menu, choose Protect Document, and enter a password. (In Excel 5.0 select Protection from the Tools menu and then choose unprotect sheet, and enter a password.)

  4. Save the document in Excel 2.x format again.

The document can now be used in Excel 2.x as a protected document.

REFERENCES

"Microsoft Excel User's Guide," for the Macintosh, version 3.0, pages 559-562

KBCategory: kberrmsg
KBSubcategory:

Additional reference words: 5.00 3.0 3.00 4.0 4.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: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.