I have a pivot table that runs a OLAP Query and can take between 1-4 hours to pull data from a database when it updates. The problem is each day I need to make 2 filter changes before I gather the information. Each time I make a change to one of the filters the query is run and I have to wait forever before I can run the second filter.

Is there anyway to turn off the auto refresh/run query so that I can set both filters then run the OLAP Query?