<p>I have a pivot table on an olap cube. I can go into a page field and manually deselect multiple items. How can I do this in VBA based on a list of items I need excluded? (n.b. I do not have a corrresponding list of items I need included)</p>

<p>I know how to exclude these items in other ways, by altering the underlying query for example. I specifically want to replicate the user action of deselecting items in the pivot.</p>

I apologize for this example being in C#, but I really don't know enough VBA to translate it (perhaps someone can edit this entry and add it below).
Are you refering to something like this?
```
```
((MOE.PivotField)pivotTableObject.PivotFields("[NAME]")).Delete();
```
```
Where MOE is the Microsoft.Office.Interop.Excel namespace and [NAME] is the name of the field you want to remove