Suppose you have a PivotTable with a totals row at the bottom (and some lines of actual data). If you: 1. Click somewhere in the PT's data area 2. On the menu, click Data > Sort... 3. Click Sort You'll notice two problems. While the entire PivotTable is selected, including header rows, the dialog doesn't have "Range Contains Column Labels". But - that's the minor issue (although maybe it also merits a bug). The bigger problem will be that the "Total" or "Total Result" row will now be placed according to its value, so that if you sorted-descending on a certain column, then the "total" will appear as the first row under the header.
That is similar to the sorting problem with database ranges, that I have reported in bug 162964.
(In reply to Regina Henschel from comment #1) > That is similar to the sorting problem with database ranges, that I have > reported in bug 162964. Indeed, almost the same issue :-) I wonder if it's the same place in the code though. Perhaps one of the developers could tell us.