I'm using a Dynamic Data Source for a Pivot Table, and for some reason it isn't caputing all of my data....it is only capturing 1431 rows of data and I have 1495. Formula I'm using is =OFFSET('Store Delivery Issues'!$A$1,0,0,COUNTA('Store Delivery Issues'!$A:$A),13)
What would cause it to not capture my last 64 rows of data? Cells are formatted exactly the same?
What would cause it to not capture my last 64 rows of data? Cells are formatted exactly the same?