Excel: What Happened? Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

PivotTable Fields PivotTables use fields to organize and calculate the rows and columns. These fields come from the labels in the first row (the header) from the OriginalData spreadsheet.   The picture on the top of this page is a screen shot of the OriginalData spreadsheet.   Look for the PivotTable Field List on the right side of your screen.  How do they compare? PivotTable Tools ->Field List