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?