I've created an excel webpart in sharepoint , importing the named range from the spreadsheet I've created.
The spreadsheet is saved on a trusted location.
The excel spreadsheet's pivot are created by pulling in data from sql server.
However when I try to refresh the data in the webpart, I get this error "Unable to retrieve external data for the following connections..."
Do you perhaps know of a workaround this??