I have an Excel workbook in a document library which is programmatically overwritten with a new version every so often. I have set up a web part for Excel Web Access to display the workbook on a page. This is all SharePoint 2010.
As I understand it.. when a user visits the page, Excel services starts a session and caches the workbook for that session. Refreshing the page maintains the cached version, even when the file has been updated. Closing the browser and reopening successfully clears the session and retrieves the latest.
Interactivity and editing has been disabled anyway. Is there any way to disable this session caching per workbook, or can I programatically clear the session somehow? Basically, with every refresh or hit of the page I want my users to see the latest data in the workbook without being forced to hit File > Reload Workbook every time.