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.

  • Would it be possible to use the XSLTListViewWebPart (The one you see on AllItems.aspx)? This one support autorefresh through ajax
    – eirikb
    Sep 13, 2012 at 6:01

2 Answers 2


Refeshing data from SharePoint list using data query is not supported in Excel Services.

Look at the list of unsupported features for Excel Services ( http://msdn.microsoft.com/en-us/library/ms496823.aspx)

I know the list is for MOSS 2007, however the only thing Microsoft changed is that they don't block workbook rendering in SP2010 (see http://msdn.microsoft.com/en-us/library/ff595319.aspx).


I have an article that shows you how to do this.


exact article is here

  • While this may theoretically answer the question, we prefer inclusion of the essential parts of the answer here, and to provide the link for reference. See answer for general guidelines.
    – SPDoctor
    Aug 27, 2013 at 10:49
  • The solution suggested by user1944 only works on premises, if you have access to the SharePoint server. OP certainly can't use it. Sep 7, 2016 at 12:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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