Pivot Table does not remove old data when refreshing

G

Guest

Sometimes I re-use the same pivot table, but just change the data. The
column headers are always the same, but the row "headers" change.

When I refresh the table, the new data comes up properly, but the old row
headers remain in the drop-down lists at the top of the table.

Does anybody know how to "purge" the old data from a pivot table?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clear row label data in pivot table 2
Pivot table filter list - listing irrelevant subcategorys 1
Pivot ungrouping on refresh? 3
Excel Pivot table - need to not remember old data which has been r 3
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot Table "Data source reference is not valid" error cause? 1
Typing Over Pivot Table Rows and Columns 1
Refreshing a pivot table 1

Top