In the pivot tables that we use, we want to hide a certain number of items.
In excel 97, by choosing which items to hide from the pivot table field, we can dynamically see if there are any new items showing up in the pivot table.
However, the problem occur in excel 2002. The pivot tables...