'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel External Workbook Links Disabled on iPad and iPhone
Question details
The user is unable to update or use external workbook links in Excel for iPad and iPhone, even when the workbooks are stored in OneDrive.
- Product
- Microsoft Excel
- Device & OS
- iOS (iPad, iPhone)
- Scenario
- Attempting to access and update linked external workbooks on an iOS device.
- Observed behavior
- External workbook links function correctly on a Windows computer but are completely disabled or unrecognized when opened on an iPad or iPhone.
Ensure both your primary workbook and the linked external workbooks are fully synced to your OneDrive or cloud storage account before attempting to manage the files.
Use Excel for Windows or Excel for Web to Update Links
Since Excel for iOS does not support updating external Windows file paths, use a desktop or web environment to update the links and save the data for mobile viewing.
Excel for iOS is a streamlined mobile app that lacks support for certain desktop-level data query features. External links created on a PC often rely on Windows-specific local file paths which iOS cannot process. The most reliable workaround is to manage the refresh process on a compatible platform.
Access your OneDrive account using a desktop web browser or open the Excel desktop application on a Windows PC.
Locate and open the main Excel file that contains the external workbook links.
Navigate to the Data tab in the ribbon, select 'Queries & Connections', and click 'Refresh All' to update the data from the linked workbooks.
Save the workbook back to OneDrive. The updated values will now be visible as static data when you open the file on your iPad or iPhone.
Break Links to Convert Formulas to Static Values
If you only need to view the data on your mobile device and no longer need dynamic updates, breaking the links on a desktop will permanently convert them to static values.
Try WPS Office for a Seamless Cross-Platform Experience
If you frequently encounter compatibility issues or missing features with spreadsheet apps on mobile devices, WPS Office offers a powerful, lightweight, and highly compatible alternative. Enjoy excellent support for Microsoft formats across all your devices, including iOS, Mac, and Windows.
- 1. Download the Mobile App: Get the free WPS Office app from the Apple App Store on your iPad or iPhone.
- 2. Connect Your Cloud: Open WPS Office and easily link your OneDrive, Google Drive, or Dropbox account.
- 3. View and Edit Anywhere: Tap your .xlsx spreadsheets to open, edit, and review them seamlessly on the go.
Frequently Asked Questions
Why does Excel for iOS not support external workbook links?
Excel for iOS is designed as a streamlined mobile app and does not support all complex desktop features. External links created on a PC often rely on Windows-specific local file paths or desktop query engines that the iOS operating system cannot process natively.
Can I update external links using the Excel app on my iPad?
No. The Excel app for iPad and iPhone currently does not support updating or refreshing external workbook links. You must use Excel for Windows or Excel for Web to fetch new data.
How can I view the linked data on my iPhone without updating it?
If the file was saved with the external link values updated on a PC, you will be able to view the most recently saved static values on your iPhone, provided you do not attempt to refresh the links inside the mobile app.
Will saving my files to OneDrive fix the iOS link issue?
No. While saving to OneDrive allows you to easily access the files on your iOS device, the Excel mobile app itself still lacks the underlying feature to process and update external workbook links between multiple cloud files.
