Pivot Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use the wonderful pivot a lot. I use SQL to get dvolitile data and then
refreash the pivot. Is there a way to "scrub" the pivot memory without
starting all over, i.e., data in the pivot select is persistant from the
prior refreshed even when not in the current data set. Its correctly not in
the final pivot, but continues to appear in new select list? thx in advance
 
Back
Top