'%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 Linked Workbook Refresh Errors Between SharePoint and Local Servers
Question details
The user needs to fix an error that occurs when an Excel workbook hosted on SharePoint links to another workbook stored on a local corporate server.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to create and refresh external data links between a cloud-based SharePoint workbook and an on-premise local server workbook.
- Observed behavior
- Excel displays an error shortly after creating the link, and the linked workbook status shows 'File not in the cloud' despite using the desktop app and enabling Trust Center settings.
Ensure both your SharePoint workbook and the local corporate server are accessible from your current network, and that you are using the desktop version of Excel rather than Excel for the web.
Verify Trust Center Settings and Check External Link Status
Ensure desktop Excel is configured to allow external data connections and verify the exact status of the broken link in your workbook.
Excel for the web has limited support for linking to local server files. You must use the desktop application to manage and troubleshoot these complex hybrid links.
Navigate to your SharePoint document library in your browser, select the workbook, and choose 'Open in Desktop App' to ensure you have full functionality.
In Excel, go to File > Options > Trust Center > Trust Center Settings. Click on 'External Content' and ensure that the security settings for Data Connections and Workbook Links are set to Prompt or Enable.
Go to the Data tab on the ribbon and click 'Edit Links' or 'Workbook Links'. Locate the problematic link to your local server and check the status message (e.g., 'File not in the cloud').
Escalate Hybrid Setup Issues to Microsoft 365 Support
If settings are correct but the 'File not in the cloud' error persists, Microsoft 365 Support must investigate the hybrid environment configuration.
Try WPS Office for Seamless Local File Management
If linking files across complex cloud and local network environments in Microsoft Excel becomes frustrating, WPS Office offers a lightweight, highly compatible alternative for managing and linking your local spreadsheets without hybrid cloud sync errors.
Frequently Asked Questions
Why does Excel say 'File not in the cloud' when linking to a local server?
This error occurs because a cloud-hosted file (like one on SharePoint) cannot natively access local network paths or corporate servers without specific enterprise gateway configurations. The cloud service expects linked files to also reside in the cloud.
Can I link local server workbooks using Excel for the web?
No. Excel for the web has strict limitations on external data connections and cannot link to files stored on local, on-premise corporate servers. You must use the desktop application for these advanced data links.
How do I enable external data connections in Excel?
Open Excel and go to File > Options > Trust Center. Click 'Trust Center Settings', navigate to 'External Content', and choose to enable or prompt the user for workbook links and data connections.
