Fix External Workbook Links Disabled in Excel for iPad
Question details
Users are unable to update or utilize data references from other Excel files when using the Excel mobile app.

- Product
- Microsoft Excel
- Device & OS
- iPadOS / iOS / Android
- Scenario
- Opening an Excel file containing references to other external workbooks on an iPad or a mobile device.
- Observed behavior
- Excel displays a warning message stating that links to external workbooks are not supported and have been disabled.
Ensure you have access to a desktop computer (Windows or Mac), as mobile versions of spreadsheet applications heavily restrict dynamic external file references due to system limitations.
Open and Update the Linked Workbook on a Desktop Environment
Since Excel for mobile cannot reliably process external file paths, opening the file on a desktop environment is the most direct way to access your linked data.
External links generally require the referenced workbooks to be available in a fully supported local environment. Storing both files in a cloud service like OneDrive does not bypass the mobile app's restrictions.
Ensure your Excel workbook and its linked reference files are saved to an accessible cloud storage service like OneDrive, iCloud, or Google Drive.
Log in to a Windows or Mac computer equipped with a full desktop version of Microsoft Excel.
Open the file from your synced cloud folder and click 'Enable Content' or 'Update Links' when prompted by Excel to refresh the external data references.

Convert External Links to Static Values
If you only need to view the data on your iPad without actively updating the source, breaking the links on a desktop first will remove the error message.
Try WPS Office for Your Cross-Platform Spreadsheet Needs
If you frequently encounter compatibility limitations with Microsoft Office mobile apps, WPS Office provides a free, lightweight, and highly compatible alternative. It offers a seamless transition between desktop and mobile environments with excellent format retention.
- 1. Download the app: Get WPS Office from the official website or your device's app store.
- 2. Sign in to cloud storage: Open the app and connect your preferred cloud drive to access your documents.
- 3. Open your files: Tap on your .xlsx files to open them instantly with high fidelity and full formatting support.

Frequently Asked Questions
Can I use OneDrive to fix the external link issue on my iPad?
No. Even if both the main workbook and the referenced external workbook are stored in the same OneDrive directory, the Excel mobile app lacks the backend engine to process and update external file paths.
Why does my workbook show a Power Query error on mobile?
Power Query and Power Pivot rely on desktop-specific data modeling engines and local processing power. These advanced data connection features are currently unsupported in Excel for iPad, iOS, and Android.
Are there any mobile spreadsheet apps that allow external workbook linking?
Generally, no. Most mobile spreadsheet applications restrict dynamic external linking due to strict app sandboxing policies on iOS and Android, which prevent apps from freely pulling data from unassociated background files.




