I am using SharePoint 2010.
I currently have a list that gets updated many times throughout the day.
I currently have an Excel Web Part with graphs and summary tables on the first tab, and its data source on a second tab. On the second tab, the data source comes from a .iqy file that links to the SharePoint list.
Here's my issue: In order to update the source, I am having to manually download the file, refresh the data, and re-upload it to SharePoint.
Is there a way to make this data update every 15 minutes or so? Can I add some kind of button that would refresh the data source?
My initial research has suggested this:
- Use PowerPivot (not an option, I am in a corporate environment and can't install it)
- Use the SQL Server Reporting Services(SSRS) to query the SharePoint list, and deploy the SSRS report to SharePoint library
Maybe another approach may be better. I appreciate any advice in advance. Thank you.