Hi,

I have a pivot table that's been developed in Excel 2007 using compatibility mode to save in 97-2003 format.

I then have a macro that reads through values in a field, and filters the field down based on the values. This works great on several people's computers, except for one. When I debugged it on this person's computer, I saw that it was actually reading values that were no longer in the source of this table. So, I went into PivotTable options->Data tab->Retain Items and switched this from Automatic to None. On this person's computer, it then found just the correct values in the field. But, it now failed on all computers when I tried to filter by using the PivotItems.Visible property. So, I switched it back to Automatic, and it worked again except on this one computer.

Does anyone have any better suggestions on clearing these phantom values?