1

I am trying to use an Excel Web Part that connects to a list in Sharepoint 2010.

On my local drive the spreadsheet updates when I open it and all is well but when I uploaded to sharepoint the data will not refresh Instead I get

Unable to refresh data for a data connection in the workbook. Try again or contact your system administrator. The following connections failed to refresh: list42901

I believe it is becuase the file connection iqy file is on mylocal?

How do I change that?

  • I followed the steps in this site sharepointboost /blog/ use-the-sharepoint-2010-excel-service-to-create-a-bi-tool – user14522 Jan 30 '13 at 19:36
  • Which version of excel are you dealing with – Muhammad Raja Jan 30 '13 at 20:33
  • I am using MS Excel 2010 – user14522 Jan 31 '13 at 14:53
1

Create a Data Source document library in your Sharepoint site and upload the iqy file there. Check it in and approve it. Rebuild your workbook to use that datasource. Publish via Excel Services.

  • I did the above but I still get Unable to refresh data for a data connection in the workbook. Try again or contact your system administrator. The following connections failed to refresh: list42901 – user14522 Jan 31 '13 at 15:54
  • I'm having the same issue... still not able to resolve it. – Khalifa Sabt Jan 12 '16 at 8:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.