Recalculating a spreadsheet with PI functions in SharePoint 2010

Discussion created by DDeCastro on Oct 18, 2012
Latest reply on Oct 22, 2012 by Asle Frantzen

I have a spreadsheet that displays the current value of several tags as well as the calculated hourly max load for the current and previous day.  I was able to upload to the SharePoint server and I can see the data when I open the web part page, but to get new data I have to "Reload Workbook".  Is there a way I could have the version on the SharePoint server continuously or periodically re-calculate and display the values?