Excel Pivot Tables

Does anyone know how to clear out the autofilter buffers on a Pivot Table?

I use a standard worksheet which is formatted to have several columns of data pasted into it. There are then several other columns containing formulas that act upon the pasted data.

The worksheet also contains a pivot table targetting the data sheet. The problem I have is that I import one months worth of data into a sheet and refresh the pivot table. The principal column is a date field and the pivot table allows you to filter by date. However I then clear the data sheet, import new data and refresh the pivot table. Although the deleted data is gone from the pivot table, the option to filter by the deleted data remains. This results in huge autofilter lists when there may be only a couple of filterable items in the current data.

Any ideas anyone?

  VoG II 21:31 05 Aug 04

I don't use Pivot Tables myself (have experimented but ...).

Does click here help?

That looks like it will do the trick. I will give it a try at work tomorrow.

Thanks for your help.

This thread is now locked and can not be replied to.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

These are the Best Christmas Ads and Studio Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…