Home.NETSharePoint Excel Services ExternalDataRefreshFailed – Unable to retrieve external data for the following connections:{0}

SharePoint Excel Services ExternalDataRefreshFailed – Unable to retrieve external data for the following connections:{0}

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.

Share:

Leave a Reply

You May Also Like

In this post, you’ll learn about the error message “WorkbookNotSupported – The file you selected cannot be opened because it...
  • .NET
  • December 17, 2022
In this post, you’ll learn about the error message “SpecifiedRangeNotFound – The requested range does not exist in the sheet.”...
  • .NET
  • December 17, 2022
In this post, you’ll learn about the error message “SheetRangeMismatch – The sheet provided as the sheet argument is not...
  • .NET
  • December 17, 2022