I have a sharepoint page that I am working with and it contains an Excel Web Access Web Part. That EWA Web Part is used to display and filter a large report that connects to an OLAP cube, and takes at least 1 minute to load.
There are 2 filters connected to this report, a plain text filter web part and a performance point filter Web Part that pulls data from our OLAP cube for filtering by.
When I open this page I don't want the data to refresh in the workbook, as this wastes time. I would prefer if it merely opened the version of the workbook that is saved into the documents library without refreshing the data connections.
Is there a way to prevent the data connection from automatically refreshing the workbook when I open the SharePoint page? All that needs to be done is merely opening the saved version of the workbook without reloading it.
It seems that the data refreshes because the filters send their values on page load, is there any way to prevent this?
I am on SharePoint 2010.
Thanks in advance.