This is an age old problem, but I've never been able to get a fix or
workaround.

I am using Excel 2003 SP2, on Win XP SP2.

The problem is, when the source data has certain information disappear, the
pivot table created from this, still shows this old data in the drop down
menus. This is very annoying, and the only "fix" seems to be to delete and
re-create the pivot table from scratch. Not really a good solution!

Surely this must have been fixed by now, I think the problem existed since
Excel 97 ?

Please help... I have been given a chunk of code whic supposedly fixes it in
2002, but I've no idea how to implement this VB code.

Steve