Olap Pivot Tables: Multiple calls to AddPageItem and performance
 

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