SHAREPOINT - UNABLE TO RETRIEVE EXTERNAL DATA

Hi ..
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??
AldenMollerAsked:
Who is Participating?
 
vikas413Commented:
Hi,

The issue may be something to do with Alternate Access Mappings (AAM), please try to check your AAM configuration.

For more information about configuring Alternate Access Mappings
check this
http://technet.microsoft.com/en-us/library/cc263208.aspx

 

Hope it helps
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.