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.
LVL 5
IsaacSharePoint Client Side DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jamie McAllister MVPSharePoint ConsultantCommented:
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. :(
0
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.

OR

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.

OR

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
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.