I have this problem, where I have to manually select the data when ever fresh data is added and the range of rows increases. Is there an option in the pivot tables to select the data automatically in the event of row increase.