If Excel is not working on your iPad, check your internet connection and Microsoft account, update Excel and iPadOS, then close and reopen the app; save any open changes before force-closing it. If the problem affects only one workbook, make a copy and try opening it in Excel for the web or on another device to determine whether the issue is the app or the file.
First identify what is going wrong
Excel problems on an iPad can look similar but have different causes. The app might close unexpectedly, refuse to open, get stuck loading, display a workbook without letting you edit it, or fail to save changes. A formula or feature might also behave differently from how it behaves in desktop Excel. Identifying which situation you have helps avoid changing settings that are unrelated to the problem.
Try opening a new blank workbook. If that works but one particular file does not, focus on the file, its format, permissions, or cloud connection. If no workbook opens, focus first on the app, iPadOS, available storage, and sign-in. If you can view a workbook but cannot change it, check whether it is read-only, whether you have editing permission, and whether your Microsoft account has access to the feature you need.
Also note where the file is stored. A workbook saved in OneDrive depends on an internet connection for current cloud changes, while a file saved locally on the iPad may be available without a connection. Knowing the storage location makes it easier to tell a sync delay from an app failure.
Try the basic app and iPad fixes
Start with low-risk steps. Before closing Excel, wait for any saving indicator to finish and check that important changes are saved. If the app is frozen and will not respond, you may have to close it, but unsaved edits could be lost.
- Check that the iPad can reach the internet by opening a webpage. If you use a VPN or a managed work network, try a permitted alternative connection to see whether the network is involved.
- Update Excel from the App Store. Open the App Store, tap your account picture, and check for available app updates.
- Check for an iPadOS update in Settings > General > Software Update. Install updates only when appropriate for your device and allow time for the iPad to restart.
- Close and reopen Excel. On an iPad without a Home button, swipe up from the bottom and pause to show open apps, then swipe Excel up. On an iPad with a Home button, double-click the Home button and swipe the Excel app away.
- Restart the iPad, then open Excel again. This can clear a temporary system or app state without removing your workbooks.
- Check Settings > General > iPad Storage. If the iPad is nearly full, remove or move items you no longer need before retrying; leave adequate space for downloads, updates, and temporary files.
Do not delete and reinstall Excel as the first step. Files saved only on the device, or unsynced edits, may not be recoverable after removing an app. Confirm that important workbooks are safely stored in OneDrive or another backed-up location before reinstalling. If you do reinstall, download Excel from the App Store and sign in with the account that has access to your files.
Check your Microsoft account and editing access
Excel may open but limit editing when you are signed out, using the wrong Microsoft account, or trying to use a feature that requires an eligible Microsoft 365 subscription. Subscription terms and included features can change, and access can depend on the device and account. If Excel displays an activation, subscription, or read-only message, follow the prompt and verify the account shown in the app rather than assuming the workbook is broken.
For a personal account, check that the subscription is active and that you are signing in with the account that owns it. A work or school account may be controlled by an organization. Its administrator can restrict editing, sharing, sign-in, or access from unmanaged devices. If a company workbook works on a managed computer but not on the iPad, ask the organization’s IT support whether its sign-in or device policies allow Excel for iPad.
Editing permission is separate from subscription access. A workbook owner can share a file as view-only, or your account may not have permission to edit its OneDrive or SharePoint copy. Ask the owner to confirm your access. If the workbook opens in a preview or read-only state, use Excel itself and check that you opened the intended account’s copy, not an attachment or preview.
When a workbook will not open or looks different
Excel for iPad handles common Excel workbooks, but it is not identical to Excel for Microsoft 365 on Windows. A workbook can rely on features, connections, or automation that the iPad app does not support in the same way. If only one file fails, ask the sender to save a standard .xlsx copy when possible, or open a copy in desktop Excel to identify features that may be causing the difference.
Macro-enabled .xlsm workbooks need special care: Excel for iPad does not run VBA macros. The workbook may still be viewable, but a button or process that depends on a macro will not work as it does in desktop Excel. Do not enable or rely on a macro-based workflow on the iPad; use a supported desktop version for that task.
Some advanced desktop capabilities, add-ins, data connections, and specialized editing tools may be unavailable or behave differently in the iPad app. A workbook that uses an external data source, a complex model, or a feature added in a newer Excel version may therefore display differently. The exact behavior depends on the workbook and feature. Compare the file in desktop Excel before concluding that data has disappeared or been changed.
Legacy formats such as .xls and text formats such as .csv can also have limitations. CSV files contain tabular text rather than a full Excel workbook: they do not preserve multiple sheets, cell formatting, charts, or other workbook features. If the file opens with missing formatting or only one sheet, that may be a format limitation rather than a fault with the iPad. Keep an .xlsx copy when you need the workbook’s structure and features.
If you received the workbook as an email attachment, save a separate copy before editing. Then open that copy in Excel and check whether it is stored locally or in a cloud service. A damaged download, an incomplete sync, or a file that is still being edited by another person can complicate troubleshooting. Testing a copy protects the original while you investigate.
Fix OneDrive and saving or syncing problems
A workbook can appear to save in Excel while a cloud upload is still pending. If the app reports a sync problem, check the connection and give the upload time to finish. Open OneDrive or the relevant SharePoint location and confirm that the newest version appears there before switching devices or removing the local file.
- Check that Excel is signed in to the account that owns or was given access to the workbook. A personal OneDrive and a work or school OneDrive are separate locations.
- Open the file from its cloud location again and check whether another copy has a similar name. Editing an old download can make it seem as though recent changes vanished.
- If you are offline, keep working only if the workbook is available locally and Excel allows editing. Reconnect before relying on the changes being available elsewhere.
- When a conflict appears, compare the available versions before choosing one. Avoid overwriting a newer copy until you know which version contains the changes you need.
For important work, keep a second copy before resolving a conflict. Do not repeatedly tap Save or make several competing copies without checking their locations; that can make it harder to identify the current version. If a work or school file still will not sync, the account’s sharing permissions or organization policies may need attention from its owner or administrator.
When Excel crashes, freezes, or feels slow
Large workbooks, many open apps, limited free storage, or a temporary app issue can make Excel slow or unresponsive. Give a large file time to load, especially if it contains many sheets, formulas, charts, or images. If the iPad becomes hot or the app repeatedly closes, stop retrying the same file and first make sure there is a safe copy stored elsewhere.
Try the blank-workbook test again. If a blank file works reliably but a large workbook does not, the workbook may be demanding more resources or using a feature that is not well suited to mobile editing. If Excel crashes with every file, update and restart the iPad, check storage, and then consider reinstalling only after confirming that local files and unsynced edits are backed up.
When contacting Microsoft Support, include the iPad model, iPadOS version, Excel version, the exact error message, and whether the issue occurs with every workbook or just one. For a work or school account, contact your organization’s support team as well. Do not send a confidential workbook unless your organization’s rules permit it; a description or sanitized sample may be enough to explain the problem.
Understand the iPad app’s limits and alternatives
Excel for iPad is useful for reviewing and editing spreadsheets away from a computer, but it is not a full replacement for Excel on Windows. The touch interface and smaller screen can make extensive formatting, complex workbook maintenance, and precision editing slower. Some desktop tools and workflows are not available, and VBA macros cannot run in the iPad app. This is a capability difference, not necessarily a sign that the installation is broken.
Choose the route that fits the task:
- Excel for iPad: Use it for routine viewing and editing when the workbook’s features are supported and the file is accessible on the device.
- Excel for the web: Try the browser version through Microsoft 365 when you want to see whether a problem is specific to the app. It also has its own feature limits and requires a suitable browser, account, and connection.
- Excel for Windows or Mac: Use desktop Excel for workflows that depend on VBA, advanced desktop tools, or a feature that is missing or limited on iPad. Mac and Windows versions also differ in some capabilities, so check the specific feature you need.
- Another spreadsheet app: This can be convenient for a simple table, but importing a complex Excel workbook may change formatting or functionality. Keep the original and compare results before relying on a converted file.
One common misconception is that every Excel feature should work identically on every device because the workbook has an .xlsx extension. The extension identifies the file format, not the complete set of features available in each app. If a particular desktop workflow is essential, confirm that it is supported on iPad before moving the whole process there.
Frequently Asked Questions
Why does Excel on my iPad say I can only view the file?
Check whether you are signed in to the right Microsoft account, whether the file owner gave you editing permission, and whether Excel is asking you to activate a subscription for the feature or device. A shared link or attachment may also open a view-only copy.
Can Excel for iPad open macro-enabled files?
It can open some .xlsm workbooks for viewing, but Excel for iPad does not run VBA macros. If a workbook depends on a macro to refresh, calculate, or complete a task, use a supported desktop version of Excel for that workflow.
Why are my Excel changes not showing on my other device?
Confirm that the file is saved to OneDrive or SharePoint, Excel is signed in to the same account on both devices, and the iPad has finished syncing. Check for duplicate copies or a version conflict before replacing any file.
Will uninstalling Excel delete my spreadsheets?
It may remove data stored only within the app or leave unsynced work unavailable, so do not uninstall until you have checked where each important file is stored and confirmed that cloud copies are current. Back up local files first.
Can I use Excel on my iPad without internet?
Some files already available on the iPad may be usable offline, but cloud files need a connection to sync changes or access the latest version. Reconnect and verify that edits have uploaded before relying on them from another device.
Related
- Find a Circular Reference in Excel and Trace Its Source
- Identify Circular References in Excel: A Step-by-Step Guide
- Enable Circular References in Excel: Step-by-Step
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Google Sheets Apps Script Not Working? Fixes to TryIf Apps Script is not working in Google Sheets, first check whether the script is attached to the…
- XLOOKUP Excel Not Working? Fix Common Errors and CausesIf XLOOKUP is not working, first check that your Excel version supports it, then confirm the lookup and…
- Excel Not Recognizing Dates? Fix Text and Format IssuesIf Excel is not recognizing dates, check whether the cell contains a real date value or text: apply…
- Excel Not Responding: How to Fix ItIf Excel says Not Responding, first give it a few minutes to finish any calculation or file operation,…
- Filter by Color in Excel Not Showing? Fix ItIf Filter by Color is missing in Excel, open the filter arrow on the column that actually contains…
- Excel Solver Not Working? Fix Setup and Model ErrorsIf Excel Solver is not working, first make sure the Solver Add-in is enabled in desktop Excel, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.