Excel: How do I remove redundant selections from a pivot table's page fields?
Posted on 2002-06-19
I have a pivot table which is regularly refreshed from a large DBF datasource (which is accessed by opening it within EXCEL). However when the pivot table is refreshed, some of the pivot table's page fields continue to show selections relating to the previous dataset. When these are selected a blank pivot table is generated because such items are not represented in the new dataset. Why are these out of date selections shown and more importantly how can they be removed? Is VBA required?
Thanks in advance