Microsoft KB Archive/89982

From BetaArchive Wiki

XL: Error Message "Cannot Import Protected File" Opening Password Protected WK3 or WK4 File



The information in this article applies to:


  • Microsoft Excel 97 for Windows
  • Microsoft Excel for Windows, 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.



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 5.0 8.00 97 123 XL98 XL97 XL7 XL5 XL4

Keywords : kb3rdparty xlloadsave xl123Quattro
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
Technology :


Last Reviewed: April 12, 2000
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.