How to Stop the Excel Encrypted and Password-Protected Warning with WPS Office
Question details
The user needs to stop Microsoft Excel's warning that appears when opening an older workbook that is both encrypted and password-protected, which recommends converting the file to the modern Office Open XML format for stronger encryption.
- Product
- Microsoft Excel and WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user opens an older Excel workbook that is encrypted and password-protected, and wants to avoid the warning that recommends converting it to the modern Office Open XML format.
- Observed behavior
- Microsoft Excel displays a warning that the older encrypted and password-protected workbook should be converted to the Office Open XML format for stronger encryption.
Make sure you have the workbook password and close the file in Microsoft Excel before editing it in WPS Office, because an open workbook may be locked and the password is required to save the converted XLSX file.
Save the Workbook as an XLSX File and Reapply Password Protection in WPS Office
Use this solution when the warning appears for an older Excel binary workbook or when the file must stay password-protected after conversion.
Older Excel file formats such as .xls use weaker encryption settings. Microsoft Excel detects that combination and recommends the Office Open XML format, which uses stronger AES-based encryption and does not trigger the same warning.
Launch WPS Office, open WPS Spreadsheets, and open the encrypted workbook. Enter the existing password when prompted.
Go to File > Save As, choose a save location, and set the file type to Excel Workbook (*.xlsx).
Click Encrypt or Tools > General Options in the Save As dialog, enter a password to open, confirm it, and save the file.
Open the newly saved XLSX workbook in Microsoft Excel and verify that the encrypted and password-protected warning no longer appears.
Convert the Protected Workbook to XLSX in WPS Office to Remove the Excel Warning
WPS Office can open the older Excel workbook, save it in the modern Office Open XML XLSX format, and apply password protection so the encrypted and password-protected warning no longer appears in Microsoft Excel.
- 1. Open WPS Spreadsheets: Launch WPS Office, click Spreadsheets, and open the encrypted Excel workbook.
- 2. Enter the workbook password: Type the existing password when WPS Office prompts for it so the file can be opened and converted.
- 3. Save As Excel Workbook: Go to File > Save As, select Excel Workbook (*.xlsx), and choose where to save the converted file.
- 4. Set password protection: Click Encrypt or Tools > General Options in the Save As dialog, enter a password to open, confirm it, and click Save.
- 5. Verify in Microsoft Excel: Open the new XLSX file in Microsoft Excel to confirm the encrypted and password-protected warning is gone.

Frequently Asked Questions
Why does Excel show the encrypted and password-protected warning?
Excel usually shows this warning for older file formats such as .xls because they use weaker encryption. Converting the workbook to the modern .xlsx Office Open XML format enables stronger encryption and stops the warning.
Will saving as XLSX remove my workbook password?
Saving as XLSX alone can save the file without protection unless you reapply a password. In WPS Office, use the Encrypt or Tools > General Options option in the Save As dialog to set a password to open before saving.
Can WPS Office open and save a password-protected Excel file?
Yes. WPS Spreadsheets can open password-protected .xls, .xlsx, and .xlsm files when you enter the correct password, and it can save them back to compatible Excel formats.
Do I need to edit the Windows registry to stop this warning?
Usually no. Converting the workbook to XLSX in WPS Office is the safer solution. Registry-based suppression may be used in some managed environments, but it depends on the Microsoft Office version and should be handled carefully.
What should I do if I do not know the workbook password?
You must get the password from the file owner or creator. Neither WPS Office nor Microsoft Excel can bypass a legitimate workbook password.




