Refresh the file while in SharePoint Library?

Dec 27, 2012 at 7:13 PM

Hi - Thanks for the contribution to the community!

Question: Can this be used to refresh content within an Excel file (with external data connections) while the file is in a SharePoint library? 

Scenerio: Sales has a graph they use in Excel Services with the source data residing in a SharePoint list.  When the list is updated, the graph is not updated because Excel Services can't do that, instead - the user must open the excel file, refresh the data connection, save and close the file. 

Thanks!
Larry

Mar 7, 2013 at 11:11 AM
Hi,

No - you should use ExcelServices (part of SharePoint) to do what you want to achieve.

Regards,
Mark.