Excel Pivot Tables (2007)

In order for Excel to properly identify the data source, all columns must be contiguous. For example, you cannot create a pivot table from data in columns A-D and columns L-N. The same holds true for rows – you cannot create a pivot table from data in rows 1-10 and 20-30. All columns of the spreadsheet with the data must have column headings. ................
................