Columns in a pivot table show data that don't exist

[RagonichaFulva]

Hello,

I have a pivot table that I filter through VBA. The problem is that when I delete the values in the range that the pivot table uses as data source, it still shows the values in the columns dropdown (even if I refresh) and when there is data in the range, the dropdown shows data that doen't exist in such range (the column Year plan only has 2012 values but it shows the 2013 option too, and when you select it the pivot table can't show any data).

The filter area, nevertheless, works correctly and data dissapear when I delete tha values in the data range.

I have checked another excel file and I see that a pivot table in there works the way I wish: no data - empty dropdown in columns and rows.

The code I use to control the pivot table is:

Please Login or Register  to view this content.

I would much appreciate your help.

[RagonichaFulva]

It seems as if the old values stayed stored in a memory in the pivot table or something alike...

[JosephP]

Yeah they do: http://www.contextures.com/xlPivot04.html

[RagonichaFulva]

Wow JosephP!

That was really an awesome link!! I think I may manage to solve this with the "Programmatically Clear Old Items -- Excel 2002 or later" section.

Thank you very much indeed!!