Forum Discussion
SRossetti
Dec 12, 2022Copper Contributor
Filter shows old dates even when not in current data
I have a file with several pivot tables where the date fields when attempting to filter shows dates back to 2012. The data only has 2021-2023 information in it. Is there a way to refresh the filter field to only show the dates of the data in the report?
Click in a pivot table. On the PivotTable Analyze tab of the ribbon, click Options.
Activate the Data tab of the dialog.
Set 'Retain items deleted from the data source' to None, then click OK.
Refresh the pivot table.
Click in a pivot table. On the PivotTable Analyze tab of the ribbon, click Options.
Activate the Data tab of the dialog.
Set 'Retain items deleted from the data source' to None, then click OK.
Refresh the pivot table.
- SRossettiCopper ContributorThanks. That worked!!
- Jeff_F_68123Copper Contributor
SRossetti - This did not work for me. I have also tried VBA to refresh the pivotCache aqnd the onld dates still show up.