Pivot table; remove old values from slicer
<p>I have two pivot tables that are connected with a slicer.<br>
The slicer is used to set the date on both pivot tables.  </p>

<p>The problem is that it keeps showing old values that are not in the data anymore.<br>
On one of the files (I have four similar files) I have deleted everything that is newer than 2016-05-09, but still the slicer is showing other dates that month.<br>
If I click on them the tables are empty so clearly it can't find any values with those dates.  </p>

<p>The old values are written with gray text.<br>
I have tried to find a solution to this issue on google but no luck.<br>
I have tried to update both tables and I have even removed the slicer and then created a new one, but still the old values does not go away.  </p>

<p>Anyone have a clue why it's doing this?
Excel 2010.</p>