'%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)
How to Open Excel 97-2003 XLS Files on an iPad
Question details
The user is unable to open or edit older Microsoft Excel 97-2003 (.xls) workbooks directly using the Microsoft 365 application on an iPad.
- Product
- Microsoft Excel
- Device & OS
- iPadOS
- Scenario
- Attempting to access, view, or modify legacy .xls spreadsheet files that are stored on or transferred to an iPad.
- Observed behavior
- The iPad application restricts the older .xls files to read-only access or fails to open them completely, preventing the user from editing the workbook directly.
Ensure you have access to a desktop computer with a spreadsheet application (like Microsoft Excel or WPS Office) installed, as converting legacy formats is the most reliable way to restore full editing capabilities on iOS.
Convert the .xls File to .xlsx Format on a Computer
Re-saving the older file into the modern .xlsx format on a desktop computer is the most effective way to ensure full editing capabilities on your iPad.
Microsoft 365 on mobile devices often restricts legacy Excel 97-2003 files for security and compatibility reasons. Upgrading the file format on a desktop will bypass these restrictions.
Send or transfer the problematic .xls file from your iPad to a Windows or Mac computer.
Launch Microsoft Excel or WPS Office on your computer and open the .xls file.
Click on 'File' in the top-left corner, select 'Save As', and choose 'Excel Workbook (*.xlsx)' from the file format drop-down menu.
Save the new .xlsx file and transfer it back to your iPad. You will now be able to open and edit it freely.
Test File Integrity and Read-Only Mode
Verify if the issue is isolated to a single corrupted file or if the iPad defaults to a restricted read-only mode for all legacy formats.
Open and Edit Legacy .xls Files Directly with WPS Office
Skip the tedious desktop conversion process. WPS Office for iOS natively supports opening, viewing, and editing legacy Excel 97-2003 (.xls) files directly on your iPad, offering a hassle-free and fully compatible mobile experience.
- 1. Download WPS Office: Search for and download WPS Office from the Apple App Store on your iPad.
- 2. Open the application: Launch the WPS Office app and grant the necessary permissions to access your device's local files.
- 3. Locate your file: Navigate through the app's file manager to locate the .xls file you wish to open.
- 4. Start editing: Tap on the file to open it. You can now use the built-in spreadsheet tools to edit and save your legacy workbook directly.
Frequently Asked Questions
Can I just rename the file extension from .xls to .xlsx on my iPad?
No. Manually changing the file extension using a file manager does not change the file's internal structure. Doing so can result in a corrupted file that cannot be opened on any device. You must always use the 'Save As' feature in a spreadsheet application to properly convert file formats.
Why does Microsoft 365 restrict .xls files on mobile devices?
Older Excel 97-2003 files lack the modern security and data compression features found in the XML-based .xlsx format. Mobile applications often restrict these legacy files to read-only access to prevent executing potentially unsafe macros or encountering severe software compatibility errors.
What is Protected View and should I disable it?
Protected View is a security feature designed to prevent malicious code hidden inside legacy files from executing and harming your device. You should never disable Protected View unless you are absolutely certain the .xls workbook comes from a safe, trusted, and verified source.
