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?

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

2 Answers 2

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.

2
  • 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, 2013 at 15:54
  • I'm having the same issue... still not able to resolve it. Jan 12, 2016 at 8:56
0

You can copy the content in Excel workbook (Source workbook) and pasted the copied data using Paste Link in destination workbook. Then you can get the data you want.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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