File Format & Compatibility

How to Stop the Excel Encrypted and Password-Protected Warning with WPS Office

Aamir Naveed AkramAamir Naveed Akram Nov 13, 2026 869 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Open the protected workbook in WPS Office

Launch WPS Office, open WPS Spreadsheets, and open the encrypted workbook. Enter the existing password when prompted.

2
Open Save As and choose the XLSX format

Go to File > Save As, choose a save location, and set the file type to Excel Workbook (*.xlsx).

3
Reapply password protection

Click Encrypt or Tools > General Options in the Save As dialog, enter a password to open, confirm it, and save the file.

4
Reopen the file in Microsoft Excel

Open the newly saved XLSX workbook in Microsoft Excel and verify that the encrypted and password-protected warning no longer appears.

Warning resolved: After the workbook is saved in the XLSX format with password protection reapplied, Excel uses the modern Office Open XML encryption and no longer displays the older-file warning.
Solved with WPS Office

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. 1. Open WPS Spreadsheets: Launch WPS Office, click Spreadsheets, and open the encrypted Excel workbook.
  2. 2. Enter the workbook password: Type the existing password when WPS Office prompts for it so the file can be opened and converted.
  3. 3. Save As Excel Workbook: Go to File > Save As, select Excel Workbook (*.xlsx), and choose where to save the converted file.
  4. 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. 5. Verify in Microsoft Excel: Open the new XLSX file in Microsoft Excel to confirm the encrypted and password-protected warning is gone.
Removes the encrypted and password-protected warning by converting the workbook to modern XLSX.Full compatibility with Microsoft Excel .xlsx, .xls, and .xlsm file formats.Free spreadsheet editor with a familiar ribbon interface.Built-in workbook password protection with standard encryption options.
microsoft office alternative - wps office

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.