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
add comment

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.