Fix Password-Protected Excel Files Failing to Open on iPhone or iPad
Question details
Users are unable to open password-protected Excel files on mobile devices, encountering decryption errors despite entering the correct password.
- Product
- Spreadsheets
- Device & OS
- iPhone and iPad
- Scenario
- Attempting to access and view password-protected XLSX workbooks stored in cloud drives like Dropbox or Google Drive from an iOS device.
- Observed behavior
- The file displays a 'Decryption failed' error on iPhone and iPad and refuses to open, even though the exact same file opens perfectly on a Windows computer.
Ensure you have the correct password for the spreadsheet and verify the file is not corrupted by successfully opening it on a desktop computer first.
Save the File in the Older Excel 97-2003 (XLS) Format
Converting the modern XLSX format to the legacy XLS format often bypasses decryption incompatibilities within third-party cloud storage apps on iOS.
Many mobile cloud drive previewers struggle to decrypt modern XLSX encryption algorithms. Saving the file in the older XLS format changes the encryption method to one that is more widely recognized by legacy mobile viewers.
Open your password-protected XLSX file normally using a spreadsheet program on your Windows or Mac computer.
Click on 'File' in the top menu bar, select 'Save As', and choose a location to save the new file.
In the 'Save as type' or 'Format' dropdown menu, select 'Excel 97-2003 Workbook (*.xls)' and click 'Save'.
Upload this newly saved XLS file to your preferred cloud storage (such as OneDrive or Dropbox) and try opening it on your iPhone or iPad.
Open the File Directly in a Dedicated Spreadsheet App
Bypass the limited preview capabilities of cloud storage apps by pushing the file directly to a dedicated mobile spreadsheet application.
Open and Edit Encrypted Excel Files Anywhere with WPS Office
Avoid mobile decryption errors entirely. WPS Office for iOS provides native, robust support for opening, editing, and saving password-protected XLSX and XLS files seamlessly directly from your iPhone and iPad.
- 1. Download WPS Office: Install the free WPS Office app from the App Store on your iPhone or iPad.
- 2. Access your cloud files: Open the WPS app, navigate to the 'Cloud' or 'Files' tab, and link your third-party cloud storage account.
- 3. Unlock and edit effortlessly: Tap your password-protected file. WPS Office will securely prompt you for the password and decrypt the file with full editing capabilities intact.
Frequently Asked Questions
Why does my encrypted Excel file open on Windows but not on my iPhone?
Many built-in document previewers on iOS and standard cloud storage apps lack the proper decryption algorithms required to process modern AES-encrypted XLSX files natively. Desktop software contains the full feature sets needed to decrypt them.
Will I lose formatting or data by saving my XLSX file as an older XLS format?
You generally will not lose raw data, but you may lose access to newer Excel features not supported by the 97-2003 standard, such as larger grid sizes (over 65,536 rows), sparklines, or certain advanced conditional formatting rules.
Can I remove the password on my computer to view it on my phone?
Yes. If security is not a strict concern, you can open the file on your desktop, go to File > Info > Protect Workbook, clear the password field to decrypt it, and save the file. The unprotected file will easily open on any mobile device.
