i have a pivot table in excel 2007 which connects to the AS2005 database.
i have lots of dimensions in report filter field.
(StoreCode, Year, Month, ProductCategoryCode etc...)
All filters are multiselected.
i want to change these filters. But when i change any of the filters and click OK pivot table refreshes my report.
i know that it is normal.
But i dont want to refresh the refresh the report untill i choose all my filters. My report data is very heavy so i dont want to wait everytime i change the dimension filters.
i want to select all my filters and click Refresh button in the Ribbon.
is it possible to disable auto run.
is there any way to do that?