I am trying to cycle through the pagefields of a pivot table, but the macro crashes if the items changed since the last update. For example, if the items were apple, orange, banana, and now they are apple, banana, cherry, it is still looking for pagefield "orange," and crashes. Why does the list not update, and how can I force it to re-evaluate the items? Thanks,
mb
mb