How to Fix Excel on iPad Showing Only a File Preview
Question details
The user cannot edit OneDrive files in the Excel app on iPad because documents open in a read-only preview mode without the standard editing menu bar.
- Product
- Microsoft Excel
- Device & OS
- iPadOS
- Scenario
- Opening and attempting to edit OneDrive spreadsheet files using the Microsoft Excel mobile app on an iPad.
- Observed behavior
- Excel files open in a restricted preview mode where the top menu bar is missing, making it impossible to edit the document.
Ensure that you know your Microsoft account email and password, as you will need to sign back into the Excel app after clearing your credentials.
Reset Excel Login Credentials in iPad Settings
Clearing the cached login credentials forces the Excel app to re-authenticate your account, which typically resolves the preview-mode glitch and restores full editing capabilities.
Sometimes the Excel mobile app fails to properly sync your Microsoft 365 subscription status. By clearing the old login data directly from the iOS Settings, you can force a clean connection to Microsoft's servers.
Swipe up from the bottom of your iPad screen to open the app switcher, and swipe up on all Microsoft Office applications (like Excel, Word, and PowerPoint) to close them completely.
Navigate to your iPad's home screen and tap the 'Settings' gear icon. Scroll down the left-hand panel until you locate 'Excel' in your list of installed apps.
Tap on 'Excel'. On the right side of the screen, look under the troubleshooting section and tap on 'Reset Excel'.
Find the option labeled 'Delete Login Credentials' and toggle the switch to the ON (green) position.
Return to your home screen and open the Excel app. You will be prompted to sign in again. Enter your Microsoft account details, then open your OneDrive file to confirm that the menu bar and editing tools are now visible.
Edit Spreadsheets on iPad Seamlessly with WPS Office
If Microsoft Excel continues to lock your files in preview mode or requires an expensive subscription for your iPad model, switch to WPS Office. It provides a robust, mobile-friendly spreadsheet editor that lets you view, create, and edit files on your iPad with ease.
- 1. Download the App: Search for WPS Office in the Apple App Store and download it to your iPad.
- 2. Connect Cloud Storage: Open WPS Office, navigate to the Cloud tab, and sign into your preferred cloud drive to access your existing files.
- 3. Start Editing: Tap any Excel file to open it directly in full-editing mode without subscription barriers.
Frequently Asked Questions
Why does my Excel file say read-only or open in preview mode on my iPad?
This usually happens if your Microsoft 365 subscription is inactive, you aren't signed in correctly, or the app has cached corrupted login credentials. For larger iPads, it may also happen if you are using a free account, as Microsoft requires a paid subscription to edit files on devices with screens larger than 10.1 inches.
Do I need a Microsoft 365 subscription to edit Excel files on an iPad?
Yes, if your iPad has a screen size larger than 10.1 inches (such as the iPad Pro or newer iPad Air models), Microsoft requires an active, paid Microsoft 365 subscription to unlock editing features in the Excel app.
Will resetting the Excel app delete my saved files?
No, resetting the Excel app and enabling 'Delete Login Credentials' will only clear your sign-in data and app preferences. Your documents saved in OneDrive, iCloud, or locally on your iPad will not be affected.
