Pivot Tables-Source Range continually increasing
 

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

Pivot Tables-Source Range continually increasing
 

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?

"CrimsonPlague29" wrote:

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

Pivot Tables-Source Range continually increasing
 

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).

"CrimsonPlague29" wrote:

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