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
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