Hello,
It seems like a pivot table has some kind of cache and I am wondering how to clear it.

For example,

I have a table like:

Project Date completed
aa 1-1-2012 100
bb 1-1-2012 200

Than attach a pivot table to it.

Row labels = date
Column labels = project
values = sum of completed

then change aa to cc

In the pivot table all aa, bb and cc are listed.
when there really is no aa any more.

is there a way to delete the cache.

Chart test2.xlsx

I have attached a sample.

thanks