How do I Clear old Pivot Table Fields that no longer exist
 

How can I clear old Field Names that show up on the filter list but no longer
exist in original data table (Pivot Table Source Data)

How do I Clear old Pivot Table Fields that no longer exist
 

Try right-clicking in the table and selecting Refresh Data.

"snowman" wrote:

How can I clear old Field Names that show up on the filter list but no longer
exist in original data table (Pivot Table Source Data)

How do I Clear old Pivot Table Fields that no longer exist
 

You have a few options....all available at Debra Dalgleish's website

For instructions and the vba code to run:
http://www.contextures.com/xlPivot04.html

OR....for the Pivot Play add-in the clears the items for you:
http://www.contextures.com/xlPivotPlay01.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"snowman" wrote:

How can I clear old Field Names that show up on the filter list but no longer
exist in original data table (Pivot Table Source Data)