'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Cannot Open a Password-Protected Excel File on iPhone
Question details
The user is unable to open a password-protected Excel file on their iPhone, despite entering the correct password and verifying the file opens correctly on a Windows computer.
- Product
- Microsoft Excel
- Device & OS
- iOS 16.5.1 (iPhone)
- Scenario
- Attempting to open an encrypted Excel workbook via OneDrive on an iPhone.
- Observed behavior
- After entering the password, the file fails to open and instead displays an 'Office Open XML spreadsheet' message.
Ensure your iPhone's operating system (iOS) and the OneDrive or Excel app are updated to their latest versions, as outdated software can cause encryption compatibility issues.
Save the Excel File as a New .xlsx Document on Windows
Resaving the file on a Windows computer can clear hidden metadata errors or formatting corruption that prevents the iOS app from reading the file.
Sometimes, password-protected files develop minor internal errors that desktop Excel can ignore, but mobile Excel cannot process. Creating a fresh copy often resolves this.
Access a Windows computer, open the problematic Excel file, and enter the password.
Click on 'File' in the top-left corner, then select 'Save As'.
Choose a destination, ensure the format is set to 'Excel Workbook (*.xlsx)', and save the new file.
Upload this newly saved .xlsx file to your OneDrive and try opening it again on your iPhone.
Rebuild the Excel Workbook
If saving as a new file fails, the original workbook might contain unsupported objects or deep corruption requiring you to rebuild the file from scratch.
Open Your Encrypted Excel File Directly with WPS Office
If Microsoft Excel or OneDrive struggles to open encrypted files on iOS, you can easily bypass the issue by opening your password-protected spreadsheet directly using the WPS Office app on your iPhone.
- 1. Install WPS Office: Download and install the free WPS Office app from the Apple App Store on your iPhone.
- 2. Locate the File: Open WPS Office, tap on 'Files', and navigate to the cloud storage or local folder where your Excel file is saved.
- 3. Open and Enter Password: Tap on the Excel file. When prompted, type in your encryption password to immediately view and edit your spreadsheet.
Frequently Asked Questions
Why does my encrypted Excel file open on Windows but not on my iPhone?
This usually happens due to compatibility glitches between the desktop and mobile versions of Microsoft Office, or the presence of unsupported elements within the workbook that the iOS app cannot process.
Can I temporarily remove the password on Windows to view it on my iPhone?
Yes. Open the file on your Windows PC, go to File > Info > Protect Workbook, remove the password, and save the file. You can then try opening the unprotected file on your iPhone.
What does the 'Office Open XML spreadsheet' message mean on my iPhone?
This message indicates that the mobile app recognizes the file type (.xlsx) but is struggling to render the actual content, often because the specific encryption format or file contents are not fully supported on the mobile version.
