Check out these link on a Dynamic data source (better known as a dynamic
named range)...

http://www.cpearson.com/excel/excelF.htm#DynamicRanges
http://www.contextures.com/xlPivot01.html

--
HTH...

Jim Thomlinson


"SeanF74" wrote:

I have a pivot table where the last row before the grand total has a (blank)
across all of the row label and there is no data across any of the columns
(e.g., the total of the row is 0). Is there any way to remove this blank row
from this table?

Note: My data range for the pivot table (Raw!$A$1:$AR$65536) is larger than
the amount of data I inputted to create the table (Raw!$A$1:$AR$4293). If I
change the data source to the size of the data I inputted, it removes the
(blank) line. However, I need to change the data often, and the number of
rows in the data will change and I would rather change the data source range
every time because I could forget.

Thanks,

Sean