Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data Connection Error

Status
Not open for further replies.

smmt2207

MIS
Feb 27, 2007
36
US
I have an excel spreadsheet (2007) that I have published to a dashboard as a Web Part. When I click the report opens fine and looks fine. However, I can not REFRESH the report data. I get the following error: Unable to retrieve external data for the following connections:
The database info is listed then it continues to state: Verify Data refresh in enabled (which it is) for the trusted file location and that the workbook data authentication is correctly set. (which it is) I am told be our administrator that all is set-up correctly, it must be my spreadsheet.

Sharepoint is 2007

Any ideas would be greatly appreciated.
 
By the way. The connection refresh works fine outside of SharePoint.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top