Excel Services in SP 2010

Posted on 2014-07-15
Last Modified: 2014-07-21
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.
Question by:Isaac
    LVL 31

    Assisted Solution

    by:Jamie McAllister MVP
    My take on the topic based on this thread and others;

    Is that the auto refresh you'd like isn't available to you. :(
    LVL 50

    Accepted Solution

    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:

    cheers, teylyn

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now