How can Excel be stopped from updating the cube results when a filter is applied?

Hi all,

I have an SQL 2005 Olap cube that i'm using in Excel 2003 & 2007.
I recorded a macro and applied a filter, which updated instantly.

When I ran the macro i'd recorded there was a delay while it actually applied the data for the first command (which blanks the filter and shows the whole data set).  It didn't do that when it was run in the usual manner rather than code.

    ActiveSheet.PivotTables("PivotTable4").PivotFields( _
        "[Campaign].[All Campaigns By Magazine].[Campaign Magazine]").VisibleItemsList = Array("")
    ActiveSheet.PivotTables("PivotTable4").PivotFields( _
        "[Campaign].[All Campaigns By Magazine].[Campaign]").VisibleItemsList = Array( _
        "[Campaign].[All Campaigns By Magazine].[Campaign Magazine].&[My Magazine].&[Y0502XBRO]")

Is there a method of setting the cube so it doesn't refresh the data when the filter is applied i.e.

Turn off updating.
Run 2 lines above.
Turn on updating.

I have a couple of other instances where this would be helpful when applying filters through code as well, but if i'm doing something else wrong in the example above and there is another solution i'd be very grateful to hear it anyway.

Regards,
KintonStart Free Trial