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?
Have you tryed set the Calculation Options as manual?
Button (Win) > Excel Options > Formulas > Calculation Options
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?