Keeping only actual data in the Pivot Table's choice button

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

Guest

Hi all,
I have a small question related to the pivot table in Excel
I use to change my data daily while keeping the same range
of next 30 days to come... and then to reprocess the pivot
table; so my 30 next days are moving ahead

Everything goes fine but I still hold the past dates in
the choice button while those past dates aren't found
anymore...

Is there an option to delete those past dates without
having to re-assign data...

Thanks in advance
Joël
 
Many thanks for your help, Debra
By the way, I'll read your Excel tips as well
Best Regards
Joël
 
Back
Top