How to get Pivots to update their array size?

[Tom_J_W]

Hey,

I have a Pivot which draws data from columns A:AW. Each week i add new data to the bottom of sheet it arrives but refreshing my Pivot doesn't make its array fit with the new data.

Is there a way to do this? I'm using excel 2010.

Thanks,

[benishiryo]

hi Tom_J_W. i wouldn't recommend ranging up the whole column, but if you did, it should capture the new data. 2 better alternatives:

select your data say from A1:AW1000 & press CTRL + T. check the option that "My table has headers". you can now refresh your table & it'll work.

another option is to press CTRL + F3 & press New. Name:
PivotRange
Refers to:
=OFFSET($A$1,,,COUNTA($A:$A),49)

the one in red must be a column where all cells are filled without any blanks in the data. after this, change your data source of the pivot to:
PivotRange