| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Clear a Pivot Table Cache | Excel Discussion (Misc queries) | |||
| 2003 Pivot Table Filter (items dropped in the Page Fields) | Excel Discussion (Misc queries) | |||
| Pivot Table Clear All Fiels | Excel Discussion (Misc queries) | |||
| Office 2003 pivot table filter data values | Excel Discussion (Misc queries) | |||
| Pivot Table formatting in office 2003 | Excel Discussion (Misc queries) | |||
![Conrad[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
