pivot table row/colum field (delete old items) question

[Guest]

i have several pivot tables which access external data sources. the data in the row/column fields has changed over time. with my new version of excel (2002 from 97), the row and column fields now have drop down arrows - like the page fields. is there anyway to remove these drop down arrows from the row/column fields (like in 97) - and is there a way to delete out the old item data which no longer exsits in the row/column fields??? they show all values ever associated to them wether they are in the external data source or not. the page fields only show data items which are currently available in the data source

thanks

matt

 

[Frank Kabel]

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

Frank

 

[Debra Dalgleish]

The following code will remove the dropdown arrows:
'=============================
Sub DisableSelection()
Dim pt As PivotTable
Dim pf As PivotField
Set pt = ActiveSheet.PivotTables(1)
For Each pf In pt.PivotFields
pf.EnableItemSelection = True
Next
End Sub
'==========================