Purging old data from pivot table

  • Thread starter Thread starter jbahur
  • Start date Start date
J

jbahur

Is there any way to purge old data from a pivot table? I modified th
contents of a column of data, and "refresh" put the modified data int
the pivot table but also retained the old data (which no longer exist
in the original spreadsheet). It gets confusing when I need to selec
different items for a new view, since the old non-existant data appear
to be selectable as well as the current data. Saving, closing,
reopening did not help either
 
You must log in or register to reply here.

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

Pivot Table does not remove old data when refreshing 1
Excel Pivot table - need to not remember old data which has been r 3
Pivot Table - Changes 5
Pivot Table New Data 4
pivot table space question 1
How do I remove old labels from refreshed pivot tables? 3
Clear row label data in pivot table 2
Pivot ungrouping on refresh? 3

Back
Top