reference entire worksheet for pivot table

[Nlreid]

Hi,

I'm trying to work on a few pivot tables where the data is continually refreshed when it is pulled in from our database. Each pivot table uses a different worksheet- one of which is titled "DF_Matching"

I want the pivot table to use the entire database, but because the number of records in the worksheet changes, I can't use a static reference.

So, currently the pivot table data source is "DF_MATCHING!$A$1:$R$72" but there are now 135 rows. I don't want to change it to "DF_MATCHING!$A$1:$R$135" because the next time it is refreshed, there will be more than 135 rows.

Is there a way to reference the entire sheet, or do I have to put in a large number to ensure that it catches the whole worksheet? And if I do have to put in something like "DF_MATCHING!$A$1:$R$1000", will the extra rows affect the numbers in my pivot table?

Thanks!

 

[njimack]

Consider dynamic ranges - http://contextures.com/xlNames01.html#Dynamic

 

[Nlreid]

Thank you!