I have a date filter problem with a Pivot Table in a spreadsheet with Excel2010.
I have rows filtered on transaction dates. It appears that the pivot table’s date filters are stuck: I cannot see new data pasted into the pivot table’s source data range.
I verified that the pivot table data source is the entire tab sheet in this work book: ‘DataViewDump’!$A:$AT
You can see that it does not reference another spreadsheet and there are no hard coded row limitations.
This version of the workbook was created on 11/22/2016.
When I click on my transaction date’s filter, it shows
Select all
+2016
<1/2/2016
>11/22/2016
No matter what I clear or check, I don’t see transactions that I have verified are now present in the pivot table’s data source range. I’ve refreshed and refreshed all dozens of times.
I’ve right clicked PivotTable Options>Data>Retain items deleted from the data source/Number of items to retain per field: = both none & automatic.
Are there any other settings that I am unaware of how to find that would make this filter persistent?
I have rows filtered on transaction dates. It appears that the pivot table’s date filters are stuck: I cannot see new data pasted into the pivot table’s source data range.
I verified that the pivot table data source is the entire tab sheet in this work book: ‘DataViewDump’!$A:$AT
You can see that it does not reference another spreadsheet and there are no hard coded row limitations.
This version of the workbook was created on 11/22/2016.
When I click on my transaction date’s filter, it shows
Select all
+2016
<1/2/2016
>11/22/2016
No matter what I clear or check, I don’t see transactions that I have verified are now present in the pivot table’s data source range. I’ve refreshed and refreshed all dozens of times.
I’ve right clicked PivotTable Options>Data>Retain items deleted from the data source/Number of items to retain per field: = both none & automatic.
Are there any other settings that I am unaware of how to find that would make this filter persistent?