[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 248
  • Last Modified:

Excel Services in SP 2010

Hi All,

So, we have excel services turned on in our SP 2010 site and we are able to successfully show excel charts in our webpart page.  Currently whenever there is a change to the data in excel that affects the chart, we would have to upload the new excel and then re-save from within SP for the chart to refresh.

The goal is to be able to upload the excel file with the changes and for the chart in SharePoint to automatically refresh without having to re-save the file.

is this possible?

Thanks for any help you can provide.
2 Solutions
Jamie McAllister MVPArchitectCommented:
My take on the topic based on this thread and others; http://social.msdn.microsoft.com/Forums/sqlserver/en-US/fc4858c9-a3e8-4dd3-82c9-c76ab024c35f/script-for-update-powerpivot-excel-file?forum=sqlkjpowerpivotforexcel

Is that the auto refresh you'd like isn't available to you. :(
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
If you want automatic updates of Excel data in a SharePoint environment, you may want to take a closer look at PowerPivot and install the PowerPivot for SharePoint service. This installation is not for the faint hearted, though and PowerPivot has its own learning curve and requires a solid understanding of the principles of BI (business intelligence) tools.  PowerPivot for SharePoint can be configured to schedule data updates automatically.


Depending on how complex the charts are, you might be able to use SharePoint list data and chart web parts, but the charting options are fairly limited.


As an alternative, you can use REST services to access a chart object in an Excel file that is stored in a SharePoint library. Using Excel Services and SharePoint list data, you can show Excel charts in a SharePoint view. The charts are updated dynamically when the underlying list data changes.  See Dave Paylor's article for details: http://paylord.wordpress.com/2013/04/20/excel-rest-meets-xsl/

cheers, teylyn

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Tackle projects and never again get stuck behind a technical roadblock.
Join Now