XL: Cannot Import Password Protected WK3 or WK4 Files

Last reviewed: February 2, 1998
Article ID: Q89982

The information in this article applies to:
  • Microsoft Excel 97 for Windows
  • Microsoft Excel for Windows 95, version 7.0
  • Microsoft Excel for Windows, versions 2.x, 3.x, 4.0, 4.0a, 5.0
  • Microsoft Excel 98 Macintosh Edition
  • Microsoft Excel for the Macintosh, versions 2.x, 3.0, 4.0, 5.0
  • Microsoft Excel for OS/2, versions 2.2, 3.0

SUMMARY

A Lotus 1-2-3 WK3 or WK4 file that is password protected cannot be imported into Microsoft Excel. Microsoft Excel versions earlier than 4.0 open the file as a blank worksheet without warning. Microsoft Excel versions 4.0 and later display the following message when you attempt to open the file:

   Cannot open protected file.

STATUS

This behavior is by design of the Microsoft products listed at the beginning of this article.

MORE INFORMATION

To open the file in Microsoft Excel, resave the file in Lotus 1-2-3 without the password, or save the file as a WKS or WK1 file. Microsoft Excel can import password protected Lotus 1-2-3 files in the WKS or WK1 format and prompts you for the password before the worksheet is opened.

REFERENCES

"User's Guide," version 5.0, Chapter 3 "Switching to Microsoft Excel from Lotus 1-2-3," version 4.0, pages 24-31


Additional query words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0
3.00 4.0 4.00 5.0 5.00 7.00 8.00 97 123 XL98 XL97 XL7 XL5 XL4
Keywords : xl123quattro xlloadsave kb3rdparty
Version : WINDOWS:2.0,3.0,4.0,5.0,7.0,97; MACINTOSH:2.0,3.0,4.0,5.0,98
Platform : MACINTOSH OS/2 WINDOWS
Issue type : kbinfo


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