In this post, you’ll learn about the error message “ExternalDataRefreshFailed – Unable to retrieve external data for the following connections:
{0}
The data source may be unreachable, may not be responding, or has denied access.” that you usually receive when working eith the Excel Services in SharePoint.
When working with SharePoint Excel Services, there are error codes that are generated in the SOAP exception when the errors occur in the Excel Services. You can use the SubCode property that is available in the SoapException class to identity these error codes and troubleshoot the issue.
Error Message
ExternalDataRefreshFailed – Unable to retrieve external data for the following connections:
{0}
The data source may be unreachable, may not be responding, or has denied access.
Reason for the Error
Attempts to refresh a data source inside a workbook failed.
0 is a \n separated list of connection names.
Solution
Make sure the data source is available and that you have permission to access it.
