Active Cell May Change When You Sort a PivotTable

MORE INFORMATION

Example

1. In Microsoft Excel, create a new workbook. Enter the following data in Sheet1:

   A1: Name B1: Position C1: Points
   A2: Dineen B2: R C2: 12
   A3: Kapanen B3: R C3: 27
   A4: Roberts B4: L C4: 25
   A5: Primeau B5: C C5: 22
   A6: O'Neill B6: C C6: 14
   A7: Sanderson B7: L C7: 13

2. Select cell A2. On the Data menu, click PivotTable or PivotTable Report.
3. Proceed through the PivotTable Wizard as follows:
   
   
   1. In step 1 of the wizard, click Next.
   2. In step 2 of the wizard, click Next.
   3. In the step 3 of the wizard, drag the Position field into the ROW area, drag the Name field into the ROW area, and drag the Points field into the DATA area. In the ROW area, double-click Position, select None, and click OK. Then, click Next.
   4. In step 4 of the wizard, select cell D10. Click Finish.
   The PivotTable lists the Position, Name, and total Points for each player.
4. Select cell D16. Click the Sort Descending tool on the Standard toolbar.
   
   In all versions of Microsoft Excel, the PivotTable is sorted. In Microsoft Excel versions 5.0 and 7.0, the active cell does not change. In later versions of Microsoft Excel, the active cell moves from cell D16 to cell F12 (the upper-rightmost cell in the selection) because the current selection is not an adjacent range of cells.
5. Select cell D16. On the Data menu, click PivotTable or PivotTable Report.
6. Drag the Position field out of the ROW area. Click Finish.
7. Select cell D16. Click the Sort Descending tool on the Standard toolbar.