I am creating a report in Excel 2013.
For this report I need data stored in an Excel file in Sharepoint 2013. This data in sharepoint is refreshed daily.

After some reading I created a List in Sharepoint and was able to import the data to Excel from the list. However, I didn’t realize that those lists are static and are not refreshable.

Next I tried to create a data connection using Get External Data –
From Web
And
From Existing Connections

I cant get that to work. I get the error “This Web Query returned no data”

This can not be this difficult! It must be fairly common to import data to Excel from files stored in sharepoint. So far, I can not figure it out. Any help would be appreciated.