Office 2003 pivot table filter clear

C

Conrad

H

I would like to know how in the hell does a person clear the filter items in a pivot table
If I set the Pivot data to less or no records the pivot filter items still brings back all the records that was previuosly loaded
If anyone can tell me how to do this I dub thee Lord of Excel

Many thanks in advanc
 
C

Conrad

Yee haaa I outta kick my own ass
Im da Lord of Excel. Wooptie do

IF anyone needs da code Here it i
Dim i As Intege

For i = Worksheets("WorkSheet1").PivotTables("PivotTable1").PivotFields("WhaEva").PivotItems.Count To 1 Step -
Worksheets("WorkSheet1").PivotTables("PivotTable1").PivotFields("WhaEva").PivotItems(i).Delet
Next
 
C

Conrad

I have to change my opinion of myself and make Frank Lord of da Exce

Thanks man. The link kicks ass.
 
Top