Excel Pivot Table row heading (blank) with no data in it
 

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

Excel Pivot Table row heading (blank) with no data in it
 

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

Excel Pivot Table row heading (blank) with no data in it
 

Figured it out. All i have to do in Excel 2007 is right click the field --
filter -- hide selected items.

"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

Excel Pivot Table row heading (blank) with no data in it
 

Doing that will bloat the file as it is storing a whole lot of of nothing.
Take a look at the dynamic named ranges...
--
HTH...

Jim Thomlinson


"SeanF74" wrote:

Figured it out. All i have to do in Excel 2007 is right click the field --
filter -- hide selected items.

"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