Filter Help with Pivots - External Data

[helpnexcel]

I tried both the manual method & Macro but neither seemed to work. An
guidance on exactly how to implement the macro?

Manual Method
1- Drag the pivot field out of the pivot table.
2- On the Pivot toolbar, click the Refresh button
3- Drag the pivot field back to the pivot table

and the Macro Method
Sub DeleteMissingItems2002All()
'prevents unused items in PivotTable

'in Excel 2002 and later versions
'If unused items already exist,
'run this macro then refresh the table
Dim pt As PivotTable
Dim ws As Worksheet

For Each ws In ActiveWorkbook.Worksheets
For Each pt In ws.PivotTables
pt.PivotCache.MissingItemsLimit = xlMissingItemsNone
Next pt
Next ws

End Su

 

[Debra Dalgleish]

Are you using Excel 2002, or later version? If not, you can use the
second macro to clear the old items:

http://www.contextures.com/xlPivot04.html#Clear97