Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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?

share|improve this question
    
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
add comment

1 Answer 1

up vote 0 down vote accepted

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.

share|improve this answer
    
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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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