OK-
3 workbooks (one combined, and two seperate for two different combined areas) are accessing a CUBE reporting database that does a daily extract from Siebel.
Each workbook contains approximately 15 sheets, and about 25 pivot tables.
When a refresh all is done, and the OLAP query runs, it resets ONE of the filters on almost every single pivot to include all values. There are several other filters that function just fine, but this particular filter is reset every time.
Is there a way to systematically refresh without triggering the filter reset, or a way to reset the filter for all tables automatically (even if it is a macro that has to be run on a workbook by workbook basis)? Or, is there perhaps a way to set all pivot tables to refer to one central filter for that field?
I have some VB experience, but nothing formal (unfortunately). Any help or guidance would be greatly appreciated.
Task Type.TaskTypeHierarchy (Multiple Items) (selecting several areas within a task type of SR)