I have a spreadsheet I update each week. In it, I have a Pivot Table/Chart with a Slicer that shows the work dates from the past week. Normally I just refresh the chart and the slicer changes appropriately. Today, I actually needed to change the data source to a different sheet in the workbook. The current data source has work dates from 3/28/16 to 4/2/16, but when I added a new slicer, the dates it showed were from 3/25/16 and earlier - the correct work dates weren't in the slicer at all in spite of being the only dates in the source data. What happened?