'%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)
How to Enable External Workbook Links in Excel Online and SharePoint
Question details
Users need to restore functionality to external workbook links that appear disabled or fail to update when accessed via Excel Online or SharePoint.
- Product
- Excel Online, SharePoint
- Device & OS
- not provided
- Scenario
- Attempting to view, edit, or update an Excel workbook containing data connections to other spreadsheets stored in a shared cloud environment.
- Observed behavior
- External links are disabled, greyed out, or fail to refresh due to insufficient file permissions, Microsoft 365 security policies, or mobile browser limitations.
Ensure you have the exact file names and SharePoint locations of all the source workbooks that your primary Excel file is linking to.
Grant Access to All Source Workbooks
External links will fail to update if the user viewing the main workbook does not have explicit permission to access the linked source files.
In SharePoint and Microsoft 365, permissions do not automatically cascade from a master workbook to its external sources. Every user or guest account must have at least 'Read' access to every interconnected file.
Open your primary workbook and note the names of all external workbooks supplying data to your formulas.
Navigate to the SharePoint document library or OneDrive folder where the source workbooks are stored.
Select the source workbooks, click the 'Share' icon, and enter the email addresses of the users or SharePoint guests who need to view the main file.
Ensure you grant them at least 'Can view' permissions, then click 'Send' to apply the access rights.
Open the Workbook in the Desktop Application
Excel Online and mobile apps have restricted feature sets and often cannot process complex external data links.
Adjust Trust Center Security Settings
Strict security policies in Microsoft 365 may be actively blocking external links from functioning to prevent malicious data execution.
Manage Spreadsheets Without Online Limitations Using WPS Office
If restricted online environments and complex SharePoint permission issues are slowing down your workflow, WPS Office offers a powerful, seamless alternative. Experience full desktop-grade capabilities for managing external workbook links without the hassle.
- 1. Download and install: Get the free WPS Office suite from the official website and install it on your device.
- 2. Open your workbooks: Launch WPS Spreadsheet and open your primary workbook alongside its source files.
- 3. Manage data links easily: Go to the 'Data' tab to view, update, and manage all external references without restrictive online limitations.
Frequently Asked Questions
Why do external links work perfectly on my computer but not on my mobile phone?
Mobile versions of Excel are simplified applications designed for basic viewing and editing. They lack the advanced processing engines required to fetch, authenticate, and update data from external workbooks stored in cloud directories.
Can external users (SharePoint guests) update linked workbooks?
Yes, but only if the guest account has been explicitly granted permission to access both the primary workbook and every individual source workbook that feeds data into it.
How can I check which external links are broken in my spreadsheet?
In the desktop application, navigate to the 'Data' tab and click on 'Edit Links' or 'Queries & Connections'. This will open a dialog box listing all external sources, showing their status, and providing options to update values or change the source path.
Does WPS Office support editing files with external links created in Microsoft Excel?
Absolutely. WPS Spreadsheet provides comprehensive support for reading, updating, and modifying external links and formulas originally established in Microsoft Excel, ensuring your interconnected data remains accurate.
