Pivot Table Not Including New Data When Refreshing

[zalik22]

Hi,

I have three columns of data, date, price1, and price2. When I add new rows of data, my pivot table does not include the new rows. I have to check off the new dates in the drop list and then it adds the data to the pivot table. My pivot table data source DOES include blank rows. Any tips to have the pivot table automatically include the new dates and data after refreshing and still exclude the blank rows?

Thanks!

 

[Johnny C]

Create a dynamic range and link the pivot table to the dynamic range as data source.

=OFFSET($A$1,0,0,MATCH(REPT("z",10),$A:$A),3)

Sorry i didn't read your post properly. I think this would work, it uses the default version of match
If that doesn't work you need a VBA solution

 

[zalik22]

I used a dynamic range and it worked. Thanks a lot!

Create a dynamic range and link the pivot table to the dynamic range as data source.

=OFFSET($A$1,0,0,MATCH(REPT("z",10),$A:$A),3)

Sorry i didn't read your post properly. I think this would work, it uses the default version of match
If that doesn't work you need a VBA solution