Make a pivot table a named range?

[Sundance_Kid]

Hi,

I have a pivot table (in tab 2) which is using data from a tabular view pivot table pulling from OLAP cube (tab 1)
However when I refresh the OLAP cube pivot it may add a few extra lines overnight.

However, my pivot in tab 2 does not update with the extra rows. Is there anyway to name the pivot table on tab 1 as a named range so that if extra lines are added it will be reflected in tab 2 pivot automatically?

Thanks

 

[Sundance_Kid]

Little bump