Forum Discussion
PIVOT TABLE WON'T SHOW ALL DATES
Hello, Sorry, I'm new in the pivot table world please help me.. Pivot table shows only up to nov 9 data encoded is already up to dec 20 but it won't show tried the refresh and other things bu...
Employee "Andrade F" has been selected in the slicer. Perhaps this employee only has dartes in November?
What happens if you click the 'Clear Filter' button in the upper right corner of the slicer?
she has dates until dec
when i click the clear filter from date
it shows this but it still doesn't show
also tried this
pls help
thanks
aileenc07 Could you attach a copy of the workbook (remove sensitive information)?
Thank you. The source range of the pivot table is PERFORMANCE!$A$1:$U$5795; Row 5795 is the last row of 9 November 2021.
But the data extend to row 6571. If you change the data source to PERFORMANCE!$A$1:$U$6571, you'll see the dates after 9 November in the pivot table: