Pivot Table Not Refreshing Properly?

  • Thread starter Thread starter Kenneth E. Coakley
  • Start date Start date
K

Kenneth E. Coakley

After creating a PivotTable, I discovered that there were several errors in
the underlying data which caused improper values to show up in the
PivotTable field drop-down lists.

I have since re-generated the underlying data and replaced it in the Excel
workbook. However, upon "refreshing" the PivotTable against the new data, I
find that the 'improper values' still show up in the drop-down lists despite
the fact that they no longer exist in the data!

How can I remove the bad values from the drop-down lists without entirely
rebuilding the PivotTable?

Thank you for any help!

Sincerely,
Ken
 
Debra,

Thank you so much for the link! It was exactly what I needed.

Sincerely,
Ken Coakley
 
Back
Top