Forum Discussion

SRossetti's avatar
SRossetti
Copper Contributor
Dec 12, 2022

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?

  • SRossetti 

    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.

  • SRossetti 

    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.

      • Jeff_F_68123's avatar
        Jeff_F_68123
        Copper Contributor

        SRossetti - This did not work for me.  I  have also tried VBA to refresh the pivotCache aqnd the onld dates still show up.

         

Resources