Share via

Encrypted Excel File Modified in Other Office Software Cannot Be Opened in Microsoft Excel

Bohan Wang 0 Reputation points
2025-01-24T05:51:52.0266667+00:00

Hello Everyone,

I encrypted an Excel file using Microsoft Excel's built-in password protection. Later, I opened and modified the file in WPS Office(another Office software). After saving the file in WPS, it can no longer be opened in Microsoft Excel. Excel displays an error stating that the file cannot be repaired because it is encrypted.

I’ve tried using the "Open and Repair" feature in Excel and third-party repair tools, but nothing has worked. The file contains important data, so I need help recovering it or extracting the information.

Any suggestions would be greatly appreciated.

Thank you!

Azure Disk Encryption
Azure Disk Encryption
An Azure service for virtual machines (VMs) that helps address organizational security and compliance requirements by encrypting the VM boot and data disks with keys and policies that are controlled in Azure Key Vault.
182 questions
Azure Site Recovery
Azure Site Recovery
An Azure native disaster recovery service. Previously known as Microsoft Azure Hyper-V Recovery Manager.
820 questions
Microsoft 365 and Office Development Other
Microsoft 365 and Office Install, redeem, activate For business Windows
Microsoft 365 and Office Excel For business Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jiajing Hua 18,060 Reputation points Moderator
    2025-01-24T07:26:48.7+00:00

    Hi @Bohan Wang

    WPS may not correctly support or be compatible with Excel's encryption method when saving files, which results in the structure of the encrypted file being destroyed and Excel unable to correctly parse the file.

    Can this file continue to be opened in WPS?

    If yes, I suggest you cancel the encryption for a test. You may also save this file as a .csv or .xml file.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.