How to Fix Shared Excel Workbooks Crashing on iPad and iPhone
Question details
The user needs to stop a shared Excel workbook from crashing when accessed or co-authored on multiple iOS devices.

- Product
- Microsoft Excel
- Device & OS
- iOS (iPad and iPhone)
- Scenario
- Opening or co-authoring a shared workbook (around 8MB) on iOS devices.
- Observed behavior
- The workbook functions properly on desktop computers and occasionally on a single iPad, but crashes consistently when opened or co-authored on additional iOS devices.
Ensure your iPad or iPhone is connected to a stable Wi-Fi network to prevent synchronization interruptions, and save a backup copy of the shared workbook on a desktop computer before making any changes.
Simplify Workbook Contents and Check File Integrity
Reduce file complexity and eliminate potential file corruption that iOS struggles to process during co-authoring.
While an 8MB file size is usually manageable for modern iOS devices, heavy visual elements, extensive conditional formatting, and complex external links can overwhelm the mobile app's memory limits, especially during real-time collaboration.
Open the file on a desktop computer and save a copy of the workbook to test modifications without affecting the original document.
In the copied workbook, select the sheets and clear complex conditional formatting rules, break unnecessary external links, and delete heavy charts or graphics.
Upload the simplified copy back to your cloud storage (OneDrive or SharePoint) and attempt to open it simultaneously on your iPad or iPhone devices to see if the crash persists.

Update Applications and Re-sync Cloud Storage
Ensure both the operating system and Excel application are up to date to rule out known collaboration bugs.
Access via Excel for the Web
Bypass the iOS application entirely by using the web version of Excel as a temporary workaround for co-authoring.
Edit and Share Spreadsheets Seamlessly with WPS Office
If Microsoft Excel continues to crash on your iOS devices during collaboration, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative for managing complex spreadsheets without the heavy resource demands that cause crashes on mobile devices.
- 1. Download WPS Office: Install WPS Office for free from the App Store on your iPad or iPhone.
- 2. Connect your cloud: Sign in to your preferred cloud storage provider to access your existing files.
- 3. Collaborate without crashes: Open your .xlsx workbook and enjoy smooth editing and sharing capabilities on your mobile device.

Frequently Asked Questions
Is an 8MB Excel file too large for an iPad to handle?
Generally, an 8MB file is well within the capabilities of modern iPads. However, if the file contains highly complex formulas, extensive conditional formatting, or heavy cross-linking, the mobile app may struggle to render it during real-time co-authoring, leading to crashes.
Why does the Excel file work on desktop but crash on mobile?
Desktop computers have significantly more processing power and RAM than mobile devices. Complex calculations and rendering heavy visual elements in real-time collaboration demand high memory, which often exceeds the resource limits allocated to mobile apps by iOS.
How do I remove conditional formatting to stop Excel from crashing?
Open the workbook on a desktop computer, select the affected worksheet, go to the Home tab, click on 'Conditional Formatting', and select 'Clear Rules'. Choose 'Clear Rules from Entire Sheet' and save the simplified file.
Can I co-author Excel files on iOS without using the app?
Yes, you can co-author by logging into Excel for the Web through your iOS device's web browser, such as Safari or Chrome. This bypasses the local app's rendering limitations and allows you to edit online.




