I have my data in Sheet 1 columns A:T and currently down to row 1828 (Always expanding). All columns have header names in row 1.
I am creating a pivot table with a named dynamic range using =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$T),20) which works, however when i select the data source, rather than selecting only the current data ending row 1828 it shows marching ants ending at row 30788 ?
When working with my pivot i am unable to filter between dates or even group dates; i think because its trying to read a load of empty cells.
I've made sure all those cells are free of data, and there are no gaps in the column filled with dates.
I've searched for a possible solution but hitting a brick wall; any help would be much appreciated.