reference entire worksheet for pivot table

Nlreid

New Member
Joined
Jul 21, 2010
Messages
7
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!
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Watch MrExcel Video

Forum statistics

Threads
1,095,748
Messages
5,446,266
Members
405,392
Latest member
Steveoaktree1977

This Week's Hot Topics

Top