Pivot Tables-Source Range continually increasing

[Guest]

HI,

I have a set of data that is added to on regular basis, how can I
automatically capture the new data in my pivot table by just refreshing
table, without having to go and highlight the range each time .....

Thanks
Crimson

 

[Guest]

Have you tried using a named array to hold the data with plenty of spare
lines for new data. You should just be able to refresh the pivot table to
show the new data?

 

[Guest]

Have the pivot table capture the entire columns of data you are looking for.

Then, use your Row and Column drop-down poxes in the pivot to de-select
(blank).