Data Refresh Failed in Excel Services

I prepared a SharePoint Report Center portal by using SharePoint 2007 recently, but I was unable to refresh the Excel workbook on my portal and got an error message:

Unable to retrieve external data for the following connections:

Connection_Name

The data sources may be unreachable, may not be responding, or may have denied you access. Verify that data refresh is enabled for the trusted file location and that the workbook data authentication is correctly set.

I'm sure my data connection and document library are trusted and I can view the workbook without problem. Here is my detailed situation:

  • Enable Excel services and workbook refresh functionality
  • Upload an Excel workbook to a document library
  • Add a Excel services webpart and point to the newly uploaded workbook
  • Excel workbook render correctly
  • BUT, an error occur if I click "Refresh" button on the top menu

Thanks to my friend Qifeng, he told me that it's related to security restriction and execute three commands. Finally it works:

  1. stsadm -o set-ecssecurity -accessmodel delegation -ssp sspname
  2. stsadm -o execadmsvcjobs
  3. iisreset

1 Comment

  • Hello
    I have an Excel File that refreshes when it opens.
    Now I need to open that File through Asp.net code and then save file and close that file.
    then Finally read data into access.

    So, how to perform the task, can anyone help.
    Please its urgent
    thanks in advance

Comments have been disabled for this content.