The last row of a pivot table shows blanks, but there is data.

I created a pivot table from a data sheet. I am grouping on a field and I
see the detail for each group except the last group on the sheet. All the
detail is blank.

Maybe the data at the end of the data sheet isn't in the pivot table's
source range. To include it:

Right-click on a cell in the pivot table, and choose PivotTable Wizard
Click the Back button
Adjust the range so it includes all the rows from the data sheet.
Click Finish

D May wrote:
> I created a pivot table from a data sheet. I am grouping on a field and I
> see the detail for each group except the last group on the sheet. All the
> detail is blank.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html