I have a pivot table that is summarizing data from a different workbook. I do not want the pivot table to grow and shrink so I selected 'Show items with no data' on the Fields settings. This works great excpet it shows data even though the detail had been deleted, even if I refresh the table. Are old values stored in memory somehow?

Thanks,
Cory