Pivot Tables-Source Range continually increasing

  • Thread starter CrimsonPlague29
  • Start date
C

CrimsonPlague29

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
 
S

Stu Gnu

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?
 
S

Sean Timmons

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