Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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.

share|improve this question
    
Would it be possible to use the XSLTListViewWebPart (The one you see on AllItems.aspx)? This one support autorefresh through ajax –  eirikb Sep 13 '12 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).

share|improve this answer

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

http://learn.sharepoint.com

exact article is here

share|improve this answer
    
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 '13 at 10:49

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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