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

  • Thread starter Thread starter SeanF74
  • Start date Start date
S

SeanF74

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
 
Figured it out. All i have to do in Excel 2007 is right click the field -->
filter --> hide selected items.
 
Doing that will bloat the file as it is storing a whole lot of of nothing.
Take a look at the dynamic named ranges...
 
Back
Top