Learn Excel Episode 288: No Pivot Totals
Sometimes you need to take the results of your pivot table to another system. There are a few problems with the default outline view of a pivot table. First - the subtotal rows can get in the way, particularly when you have two or more fields in the row area. Episode 288 will show you how to remove subtotals from from a field.