I created a pivot table. But when I enter a new value in a cell it doesn't appear in the pivot table. I have to create a new pivot table and than I can see that new data is entered in a cell.
For instance, my pivot table holds dates as ROW LABELS and COUNT OF these. And when I enter a new date, that date is not shown in the ROW LABELS until I create a new pivot table. What's wrong ?