Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have the following scenario and would very much appreciate any advice:

I exported a list /System/Examples to Excel and then saved it as Testing.xlsx to a different document library: /System/Documents.

I have an Excel Web Access web part displaying a pivot table on a page: /Admin/Dashboard.aspx

I can then open the document from the Excel Web Access web part and enable the connection, modify the document and then save it. However, if I now refresh the connection, both my local document and Excel Web Access web part display the previous version (presumably cached) and the original document in /System/Documents is correctly updated with my new data.

If I now close the Excel document and click "Reload workbook" (not refresh connection) on the Excel Web Access web part, it will fetch my saved data.

Now, what I actually need it to do is for the Excel Web Access web part to display real time updates. Is there a way of doing this or is it just a case of manipulating the timeout values in the Trusted File Location properties in the Excel Services service application?

Thanks in advance

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.