Fix Excel Cannot Link Two OneDrive Workbooks Because Connection is Blocked
Question details
The user is unable to link two Excel workbooks stored in OneDrive because the connection is blocked, specifically when using Excel for the web or Mac.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to reference data between two workbooks stored in OneDrive.
- Observed behavior
- Excel reports that the connection is blocked, and standard Trust Center instructions are unavailable or do not match the web or Mac interface.
Ensure you are logged into the same Microsoft 365 account on all devices and verify whether you are using Excel for the Web or the Desktop application, as their features differ significantly.
Use the Excel Desktop Application to Create External Links
Excel for the Web has strict limitations on external workbook links. Using the desktop version resolves most blocked connection errors.
Web browsers and web-based applications often block complex external data connections for security reasons and feature limitations. By switching to the full desktop version of Excel, you bypass these restrictions and can easily link cloud-stored files.
Navigate to your OneDrive folder in your web browser and locate the first workbook you want to link.
Click to open the file in Excel for the Web, then select 'Open in Desktop App' from the top menu ribbon.
Perform the same action for the second workbook so that both files are open simultaneously in your local Excel application.
In the destination workbook, type '=' in the desired cell, then navigate to the source workbook and click the target cell. Press Enter to establish the link.
Use Power Query to Connect Data
If you cannot use standard cell references, Power Query provides a robust way to connect data between files.
Switch to WPS Office for Seamless Desktop and Cloud Editing
If you are frustrated by the limitations of web-based spreadsheet tools, WPS Office provides a fully featured desktop experience for free. Enjoy robust external linking, seamless cloud synchronization, and native compatibility with Microsoft Excel formats without the frustrating browser restrictions.
- 1. Download WPS Office: Visit the official WPS website to download and install the lightweight suite.
- 2. Open Your Workbooks: Launch WPS Spreadsheets and open your existing .xlsx files directly; no format conversion is needed.
- 3. Create Links Seamlessly: Use the robust desktop interface to easily cross-reference cells between multiple workbooks without blocked connection errors.
Frequently Asked Questions
Why can't I link workbooks in Excel for the Web?
Excel for the Web has restricted capabilities regarding external references due to browser security protocols and architectural limitations. Advanced data connections, including cross-workbook formulas, generally require the desktop version of Excel.
Where is the Trust Center in Excel for Mac?
Excel for Mac does not feature a 'Trust Center' exactly like the Windows version. Security and privacy settings are instead managed through the top menu by navigating to 'Excel' > 'Preferences' > 'Security', which may lack some of the specific external link toggles found on Windows.
Can I link two OneDrive workbooks using a mobile device?
No, the Excel mobile applications do not currently support creating complex external links between different workbooks. You must use a desktop application to establish these connections.
