Hello,
I'm using PivotField.AddPageItem to add filter items programatically to
an Excel Pivot table which is connected to an OLAP Cube.

In excel, the end user can add multiple filters in a dialog field
easily by selecting all of them at once in the interactive filter
dialog. However, if I try the same by calling AddPageItem multiple
times, the system becomes very slow because it queries the OLAP cube
after every call to AddPageItem. I could not find a way to suppress
these queries or to add multiple filter items at once.

Does anyone have a solution to this problem?
Thanks very much
Urs