Fix Excel File Shared from OneDrive Not Opening in iOS App
Question details
The user is unable to open a shared Excel workbook via the Excel iOS app, even though the OneDrive sharing link works perfectly in a desktop web browser.
- Product
- Microsoft Excel
- Device & OS
- iOS
- Scenario
- Attempting to open an Excel file shared via a OneDrive link on an iPhone or iPad.
- Observed behavior
- The Excel iOS app fails to load the file and displays the error message: "Can't open file. Sorry, something went wrong and this can't open."
Ensure your iPhone or iPad is connected to a stable internet connection and confirm the exact Microsoft account email address that was granted permission to view or edit the file.
Verify Account Match and Open via the OneDrive App
Ensure you are signed into the Excel app with the exact account that received the file, and bypass browser redirect issues by opening the file directly from the OneDrive app.
Authentication mismatches are the most common cause of this error. If your iOS Excel app is logged into a personal account but the link was shared to your work email (or vice versa), the app will block access.
Opening the file directly from the OneDrive app instead of tapping a browser link can reliably force the correct app-to-app authentication.
Open the iOS Excel app, tap your profile picture or the account icon in the top-left corner, and confirm you are signed in with the exact email address that received the sharing link.
Download the OneDrive app from the App Store if you haven't already. Open it and sign in using that same Microsoft account.
In the OneDrive app, navigate to the 'Shared' tab at the bottom. Locate the shared Excel workbook and tap it. It should now automatically launch and authenticate correctly in the Excel app.
Reset Excel iOS App Credentials
Clear cached data and old login sessions that might be causing a silent authentication failure in the background.
Open and Edit Shared Spreadsheets Effortlessly with WPS Office
Tired of login glitches and sync errors in the Excel app? WPS Office is a lightweight, highly compatible alternative that seamlessly integrates with cloud drives like OneDrive, allowing you to open, edit, and share your spreadsheets without the hassle.
- 1. Download WPS Office: Get WPS Office for free from the Apple App Store and launch the application.
- 2. Add Cloud Storage: Navigate to the 'Open' tab, tap on 'Add Cloud Storage', and select OneDrive from the list.
- 3. Log In and Open Files: Sign in securely with your Microsoft account to instantly access and edit all your shared Excel files.
Frequently Asked Questions
Why does the OneDrive sharing link work in Safari but not in the Excel app?
Safari and other web browsers maintain separate login sessions and cookies. You might be logged into the correct account in Safari, while the Excel app is either logged into a different account, using an expired session token, or experiencing an app-to-app routing issue.
Can permission restrictions cause the 'Can't open file' error on iOS?
Yes. If the person who shared the file utilized the 'Block download' feature when creating the link, the file is strictly limited to browser viewing. Attempting to open it in any dedicated mobile or desktop application will result in an error.
How do I force the Excel app to update its synced files list?
You can force a manual sync by opening the 'Recent' or 'Shared' tabs in the Excel app and swiping down from the top of the screen until a loading spinner appears. If that doesn't work, signing out and signing back in will force a complete refresh.
