I have built a rudimentary dashboard using Excel and PowerPivot Gallery on SharePoint 2010. I successfully exported the first dataset to a SharePoint List that I can access from my dashhboard, making it fairly portable. (Whoop!) I've also found that I can create a bunch of new lists. But I have not figured out how to update these lists daily.
The most critical is an existing Odata connection: DataFeed_2_teams-company-com IMData. I am trying to update that list from the new report (.xls format). After saving it as .xlsx then closing and reopening, Odata and the existing connection are now enabled. But when I try to connect, Excel tells me, "We can't use the data from this feed. Make sure the external data feed server is available and that your connection information is correct." The connection is available and I'm using the "authenticated user's account".
I really don't mind if the data is deleted every day.
Any ideas?
-=-=-=-=-=-=-=-=-
Another thing I've tried is exporting the data through the Table menu. But since the list already exists, I can't do anything wi