Office 2003 pivot table filter clear
 

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

Office 2003 pivot table filter clear
 

Hi
have a look at
http://www.contextures.com/xlPivot04.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Conrad" schrieb im Newsbeitrag
...
Hi

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 advance

Office 2003 pivot table filter clear
 

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

Office 2003 pivot table filter clear
 

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

Thanks man. The link kicks ass.

Office 2003 pivot table filter clear
 

Hii
lol
the thanks should go to Debra :-)

--
Regards
Frank Kabel
Frankfurt, Germany

"Conrad" schrieb im Newsbeitrag
...
I have to change my opinion of myself and make Frank Lord of da Excel

Thanks man. The link kicks ass.